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?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are statistics?

0 Answers  


What is difference between oltp and olap?

0 Answers  


Can coalesce return null?

0 Answers  


How to provide values to stored procedure parameters in ms sql server?

0 Answers  


What are the system database in sql server 2008?

0 Answers  






here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,


How can you check the level of fragmentation on a table?

0 Answers  


Do comments need to go in a special place in sql server 2005?

0 Answers  


What are the pre-defined functions in the sql server?

0 Answers  


do views contain data ?

0 Answers   MCN Solutions,


last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,


what is the system function to get current user's user id? : Sql server database administration

0 Answers  


Categories