I need an sql statement I can execute that will return the name of a stored procedure that is currently running against a given database. This will help me check if I have a hung proc that is killing performance. We are running MSSQL 2008 R2. THanks!
You could configure and use SQL profiler to keep track of stored procedure running for long time.
Also take a look at this article:
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…