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

Answer / sunilkumar

run rebuildm.exe..if you dont have taht please download
that exe and run on the database.it will repair the master
database

What is the Difference Between Primary and Foreign Key?

0 Answers   Accenture, Deloitte, JPMorgan Chase, Maveric,

---

Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,

---

explain different types of cursors? : Sql server database administration

0 Answers  

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  

---

What are sparse columns?

0 Answers  

---

Explain isolation levels that sql server supports?

0 Answers  

---

What is the difference between distinct clause and group by clause?

2 Answers   HHH, Value Labs,

---

How to create a view with data from multiple tables?

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

How to create a scrollable cursor with the scroll option?

0 Answers  

---

How to view the error log for any specific instance? : sql server database administration

0 Answers  

---