Answer Posted / se

Run Setup.exe to rebuild, verify, and repair a SQL Server
instance, and rebuild the system databases. This procedure
is most often used to rebuild the master database for a
corrupted installation of SQL Server 2005.

In Sql Server 2000 this was possible withrebuildm.exe tool.

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2319

---

what is difference between view and Dip.

2396

---

What are the different methods available under sqlcommand class to access the data?

1096

---

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

1091

---

Explain the properties of subqueries in sql server?

1060

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1036

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2755

---

What are the kinds of subquery?

998

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

6843

---

What is transaction server auto commit?

1044

---

Difference between primary key and clustered index?

982

---

What is the maximum row of a size?

999

---

What do you mean by a dependent functionality in a build?

1115

---

How do I start sql server 2017?

919

---

Can you name a few encryption mechanisms in sql server?

926

---