Answer Posted / 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.

Explain acid?

1081

---

How check triggers in sql server?

991

---

How to list all columns in a table using odbc_columns()?

976

---

Explain sub-query?

955

---

Why the trigger fires multiple times in single login?

1211

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

953

---

Explain an automatic checkpoint

972

---

When we should use @@error?

966

---

How to create prepared statements using odbc_prepare()?

1065

---

what's the maximum size of a row? : Sql server database administration

1086

---

What is sql or structured query language?

1150

---

Explain what is scheduled job and how to create it?

957

---

Mention a few common trace flags used with sql server?

930

---

Explain sql delete command?

1054

---

What are the key configuration files for sql server reporting services ?

167

---