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


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

Post New Answer

More SQL Server Interview Questions

Is sql server a database?

0 Answers  


what is call by value & call by reference ?

2 Answers   Cap Gemini,


one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,


Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,


Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  






How to insert new line characters into strings?

0 Answers  


What is difference between aggregate and analytic function?

0 Answers  


Is it possible to have clustered index on separate drive from original table location?

0 Answers  


Explain the stored procedure?

0 Answers  


What is a unique key constraint?

0 Answers  


How much is a sql server license?

0 Answers  


explain different types of jions with examples briefly?

1 Answers   Zensar,


Categories