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.

What is 5nf in normalization form?

934

---

Which is the main third-party tool used in sql server?

883

---

What is a field name?

914

---

What is a filestream?

942

---

What is use of dbcc commands?

1017

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

964

---

Difference between uniqe index and uniqe constraint?

916

---

How you would rewrite the sql query to return the customerid sorted numerically?

936

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1694

---

What is row_number () and partition by in sql server?

1004

---

What happens if you delete a table that is used by a view?

941

---

What are policy management terms?

931

---

How to use copy and concatenate commands in SQL?

1064

---

Which are the two editions in which SQL Azure database available?

117

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

948

---