Which tcp/ip port does sql server run on? How can it be changed?

0 Answers  

---

Describe how to use the linked server?

0 Answers  

---

Explain how many normalization forms?

0 Answers  

---

Do you know what is blocking?

0 Answers  

---

What is a SQL Server Temporary Table?

1 Answers   Wipro,

---

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---

Why we should not use triggers?

0 Answers  

---

Difference between LEN() and DATALENGTH() in sql server ?

0 Answers   HCL,

---

How to delete an existing database user?

0 Answers  

---

What is the use of for clause?

0 Answers  

---

Display a roll having miminum marks in two subjects?

7 Answers   Patni,

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---