you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

Do you know what are the reporting services components?

0 Answers  

---

How to use old values to define new values in update statements in ms sql server?

0 Answers  

---

What is key set driven?

0 Answers  

---

What is the difference between the application object and session object?

0 Answers  

---

What is difference between materialized view and view?

0 Answers  

---

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

What is difference between aggregate and analytic function?

0 Answers  

---

Is it possible to call a stored procedure within a stored procedure?

0 Answers  

---