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  

---

How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,

---

What is de-normalization and what are some of the examples of it?

0 Answers  

---

How can you hide the sql server instances?

0 Answers  

---

Difference between Inner vs outer joins?

0 Answers  

---

How to Debug a Stored Procedure?

5 Answers   Allianz,

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

What is coalesce and check constraint in sql server?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

0 Answers  

---

What are the encryption mechanisms in sql server?

0 Answers  

---

What is global temp table?

0 Answers  

---