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.

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  

---

Explain sp_configure commands, set commands?

3 Answers  

---

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

---

CLR Integration ? what is Notification services ?

1 Answers   HCL, Satyam,

---

Do you know the cursor types?

0 Answers  

---

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

What happens when converting big values to numeric data types?

0 Answers  

---

what is maximum size of temp db?

4 Answers   iSoft,

---

Explain what is the purpose of sql profiler in sql server?

0 Answers  

---

what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

0 Answers   ADP, iSoft,

---