Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

CLR Integration ? what is Notification services ?

1 Answers   HCL, Satyam,

---

Can a table be created inside a trigger?

0 Answers  

---

What are the advantages of user defined function?

0 Answers  

---

What is the sql server 2000 version number?

0 Answers  

---

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

What are the properties of the transaction?

0 Answers  

---

Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

---

When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---

What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  

---