Answer Posted / 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 Disadvantage of indexed sequential file.

1064

---

What is Service Broker in sql server 2012?

1007

---

What is the difference between primary key and unique constraints?

940

---

List all the types of user-defined functions?

1071

---

what's the difference between a primary key and a unique key? : Sql server database administration

923

---

How do I find the port number for sql server?

955

---

Explain what are the events recorded in a transaction log?

989

---

Where in ms sql server is ’100’ equal to ‘0’?

1064

---

How can a user-defined datatype be created?

974

---

When to use Inner join & when to use subquery?

1138

---

What are sp_configure commands and set commands?

1004

---

What is the significance of master, tempdb and model databases?

1064

---

What is a primary index?

912

---

What are security principals used in sql server 2005?

954

---

Tell me what is the significance of null value and why should we avoid permitting null values?

967

---