How to check if stored procedure is running in sql server?

Question Posted / gaurav awasthi

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

More SQL Server Interview Questions

How to assign null values to variables or columns?

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

How can you list all the columns in a database?

How are the unique and primary key constraints different?

What are the basic functions for master, msdb, model, tempdb databases?

What are the grouping functions?

How will you collect the date from current date to last older 6 days date in sql server 2005

Does a specific recovery model need to be used for a replicated database? : sql server replication

How can you find out which stored procedures are recompiling?

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

What is cube dimension? : sql server analysis services, ssas

How to see the event list of an existing trigger using sys.trigger_events?

For more SQL Server Interview Questions Click Here