What is clr ddl trigger?

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

What is the security principal at the server level that represents your session?

0 Answers  

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

---

What does the not null constraint do?

0 Answers  

---

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

What is difference between index seek vs. Index scan?

0 Answers  

---

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

---

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

What is an extended Stored Procedure?

1 Answers  

---