How do you persist objects, permissions in tempdb

1 Answers  

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

Explain the disadvantages of cursors?

0 Answers  

---

What is the use of toad or sqldbx.?

0 Answers   MCN Solutions,

---

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

---

Can select statements be used on views in ms sql server?

0 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

---

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---