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   HCL,

---

What is the use of set nocount on/off statement?

0 Answers  

---

Does partitioning improve performance sql server?

0 Answers  

---

What are the restraints imposed on the table design by a merge replication?

0 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

What is the difference between a local and a global temporary table?

0 Answers  

---

How to find which stored procedure is currently running in sql server?

0 Answers  

---

ehat is the default port no of sql 2000?

2 Answers   IBM,

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

---

Do you know how to send email from database?

0 Answers  

---

What is function of CUBE ?

0 Answers   HCL,

---