I just had this same issue with SSMS tools a week or two ago.

Go to SSMS Tools -> SQL History -> Options

I believe the "Tab Content and Tab Sessions Saving"...

Doh! Good point. 😎

How about something like this:

SELECT TOP 1 @@servername AS Servername

,[min server memory (MB)] = (select value from sys.configurations where name = 'min server memory (MB)')

,[max server memory (MB)] = (select...

You might give an Extended Events session a try (assuming you are on 2012).

Check out this post by Kendra Little on BrentOzar.com:

http://www.brentozar.com/archive/2013/08/what-queries-are-failing-in-my-sql-server/[/url]

I've had great success tracking down errors using...

The default of SQL_Latin1_General_CP1_CI_AS should most likely be used.

This McAfee KnowledgeBase article seems to echo that: https://kc.mcafee.com/corporate/index?page=content&id=KB73717

I don't think there is a simple way to script out the login and back-port it to 2008 from 2012.

Maybe I'm wrong and someone will correct me (please do), but...

RCSI and Snapshot Isolation are different things.

For our databases where we have only enabled RCSI, is_read_committed_snapshot_on = 1 and snapshot_isolation_state = 0.

This is the command to turn on RCSI:

ALTER DATABASE...

Unfortunately, I never gave the pair matching idea a try. Luckily, the developers found the parameters causing the failures in the application log so the EE wasn't needed anymore.

No problem! Thank Paul Randal, not me.

Thanks Jack. I might give that a try and let you know if it works.

You are correct. It should be RPC_Starting.

Check out this kb article from microsoft. It may be of some help.

http://support.microsoft.com/kb/2874903

You could download and run sp_whoisactive. Whenever SQL Server Profiler is running, the program_name column in the output of sp_whoisactive will have something along the lines of 'SQL Server Profiler...

Try setting the database to restricted_user first and see if that helps:

ALTER DATABASE [YourDbName]

SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE;

I don't know if this is what you are looking for, but I've always used powershell to do this. If you have a master list of your servers in a...