Here is a really good look at one kind of SPAM[/url]

😛

Here's what I use (includes everything that has already been mentioned), I adapted it from an article I read here on SSCCREATE PROC [dbo].[utl_SeeWhatsExecuting]

@Duration int = NULL

AS

/*

exec utl_SeeWhatsExecuting 5000

*/

BEGIN

...

To the best of my knowledge SQL Server isn't able to track an external/3rd party application that's calling the stored-procedure, however, it can track the credentials being used that executes...

Are you talking about tempdb by chance?

kranthi.india123 (3/1/2012)

---

Thank You So much..yes i can understand that code....

but that , i can run the scheduled sql job right.automatically,every Time Run scheduled Job so every TRN should...

Yes "sp_whom2" a modified/better version of "sp_who"

USE [master]

GO

/****** Object: StoredProcedure [dbo].[sp_whom2] Script Date: 03/02/2012 08:30:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE PROCEDURE [dbo].[sp_whom2] --- 1995/11/03 10:16

@SPID...

This is also typical behavior when the query/statement you killed spans across a "linked server". If your query does perform TSQL on a linked server, you need to find...

Wow I can honestly say I've never encountered this and usually simply rename the object via SSMS...I am so glad I came across this post!

Doesn't the query I posted above give you the results you are looking for?

I don't believe there is a way to access/schedule the SSRS report that's built in to MSSQL...

I'll get back with you shortly with an example

Well said. Yes I was only sharing with the forum the bizarre code I had come across. Once again, not something I would have written or implementee but...

Agree with Sean...

You could create some sort of a Lookup table to store details about each client ie.(ServerName, DBName, Schema, etc) and then create queries that use the lookup information...

Placing the transaction inside the WHILE loop would ensure...

I checked with the developer who wrote it and apparently this particular syntax is used to delete duplicates from the table so a unique clustered index can be created. ...

Can you attached a copy of your execution plan?