February 15, 2008 at 11:42 pm
declare @p1 nvarchar(64)
set @p1=NULL
exec GetDBVersion @DBVersion=@p1 output
select @p1
go
exec sp_reset_connection
go
I see this running in profiler. What does this do that it needs to run every 5 seconds ?
February 16, 2008 at 12:58 am
Add APPLICATIONNAME column to your profiler.
Then you will know which application is running every 5 seconds.
N 56°04'39.16"
E 12°55'05.25"
February 16, 2008 at 3:06 am
In case it doesn't fill in the application name (as it's usually a property of the connection string) you could still look to see which database the query is being executed.
February 16, 2008 at 9:43 am
Was the Report Server that is not used and has now been turned off.
Thank you!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply