How to check status of stored procedure in sql server?


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

Post New Answer

More SQL Server Interview Questions

event classes in sql server

2 Answers   Accenture, AFE,


What is update_statistics command?

0 Answers  


List the different index configurations possible for a table?

0 Answers  


What is user-defined scalar function?

0 Answers  


Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,






Why do we backup Active Directory ?

0 Answers  


How to attach adventureworkslt physical files to the server?

0 Answers  


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  


How to find out the list schema name and table name for the database?

0 Answers  


Explain the working of sql privileges?

0 Answers  


Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,


Explain what are db_options used for?

1 Answers   InterGraph,


Categories