Session settings

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

  • Article

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?


2,627 reads


SQLSaturday Automatic Messages


For those who haven’t used the admin tools for SQLSaturday when an event is...

Using the Announcement/News Part of SQLSaturday


One of the interesting but not often used features of the SQLSaturday tools is...

SQLSaturday Orlando 2019 Begins


We’ll be event number 911, set for September 28th at our usual location at...

Read the latest Blogs


Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Transaction was deadlocked on lock | communication buffer resources with another

By sridharkannan7

I have a table that contains case numbers. The following stored procedure assigns a...

Microsoft and Oracle Cloud Partnership

By Kathi Kellenberger

Comments posted to this topic are about the item Microsoft and Oracle Cloud Partnership

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers