Viewing 3 posts - 1 through 3 (of 3 total)
This appears to be generated when you run a Activity Monitor in the SQL Management Studio.
May 26, 2014 at 8:58 pm
#1716568
You can execute the below specifying the search string.
EXEC master.dbo.xp_readerrorlog 0, 1, N 'searchstring', NULL, NULL, NULL, N'asc'
July 4, 2013 at 8:17 pm
#1629923
One can always use a System Startup Procedure to find the node failover, instead of having the job run every 5-10 mins.
Please read this how it can be done:
October 13, 2011 at 9:30 pm
#1394433