Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,037 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: MSSQLTips.com | Category: session settings
Rating: (not yet rated)  Rate this |   Briefcase | 2,485 reads
   Items 1 to 2 of 2   
 
Tags
troubleshooting (1)