Answer / mobin sathupally

When we install SQL SERVER totally we got six databases.
Among six four are system databases and remaining two are
user defined databases,
The system databases are 1.Master
2.Model
3.Msdb and
4.Tempdb.
The user defined databases are 1.Northwind and
2.Pubs.

Answer / sonia

guess what you want to ask is that what are the databases
that come by default? 4 - Master, Model, msdb, tempdb.

Answer / rajesh s. chandan

It depends of Microsoft SQLm Server version.
When we install Microsoft SQL Server 2008 then SQL Server
installer will install following database.
System databases
1.master
2.model
3.msdb
4.tempdb
If we configure replication then it will create
distribution database.

When we install Reporting Services (SSRS) , then it will
install ReportServer and ReportServerTempDB. We could also
install sample databases like AdventureWorks and
AdventureWorksDW.

Whenever, we restart the SQL Server, it will freshly create
tempdb database. Hope this information will help you.

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

What do I need to start working with sql studio? : sql server management studio

0 Answers  

---

Do you know what is blocking?

0 Answers  

---

What is table-valued sub query?

0 Answers  

---

What is the use of sign function?

0 Answers  

---

How to provide default values to stored procedure parameters?

0 Answers  

---

What is the use of nvl work?

0 Answers  

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

What is the difference between having clause and where clause in sql server?

0 Answers  

---

What is Trigger?

3 Answers   Misys,

---

What do you mean by sql server 2005 express management tools?

0 Answers  

---

Can we call stored procedure in trigger?

0 Answers  

---