Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Session settings Rss

   Items 1 to 2 of 2   

Session Settings

By bitbucket-25253 2010/01/12 | Category: session settings
Rating: (not yet rated) |  Discuss |   Briefcase | 3,053 reads

How to find, compare and use the exact same session settings as another user in SQL Server

When diagnosing issues in SQL Server I've found that sometimes I need to be able to mimic a user's session state when attempting to repeat an error they may be receiving. The smallest differences can completely change the outcome, so I need to ensure all the session settings (QUOTED_IDENTIFIER, ANSI_NULLS, and so forth) are identical between the production session and my test session. Is there an easy way to determine these settings with a single query?  Read more...
By Additional Articles 2009/08/31 | Source: | Category: session settings
Rating: (not yet rated)  Rate this |   Briefcase | 2,558 reads
   Items 1 to 2 of 2   
troubleshooting (1)