You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---

What is the security model used in sql server 2005?

0 Answers  

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

Where are sql server user names and passwords stored in sql server?

0 Answers  

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---

what is macro?

5 Answers   Excel, Global Innovation, Wipro,

---

Explain powershell included in sql server 2008?

0 Answers  

---

What is the basic difference between clustered and a non-clustered index?

9 Answers   Infogain,

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

Explain having clause and where clause?

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  

---