How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

---

What is after dml trigger?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

What is multi-statement table-value user-defined function?

0 Answers  

---

What is a materialized view?

3 Answers  

---

---

Can you create a logon trigger in sql server 2005 express edition?

0 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

What are the instances when triggers are appropriate?

0 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers  

---

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 inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---