How display code or Text of Stored Procedure using Sql query in Sql Server ?


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

Post New Answer

More SQL Server Interview Questions

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  


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

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,


logshipping is Any difference 2000 and 2005?

2 Answers  


What are different types of collation sensitivity?

0 Answers  


What are the tables in sql?

0 Answers  






You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  


Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,


Explain trigger classes i.e. Instead of and after trigger?

0 Answers  


What is a heap?

0 Answers  


What protocol does sql server use?

0 Answers  


What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  


What is logshipping and its purpose?

0 Answers  


Categories