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?

2009-08-31

2,627 reads

Blogs

Beginning T-SQL and Career Roadmap for Women (and Men)! #SQLSatBR

By

Download session materials and watch the recordings of my excellent sessions on Transact-SQL and...

Actual Kubernetes

By

This post continues looking at my process of learning more about Kubernetes. I’ve been...

New product: Azure Data Share

By

A brand new product by Microsoft called Azure Data Share was recently announced. It...

Read the latest Blogs

Forums

Primary Key and Clustered Index

By RonMexico

A topic I always get confused with is primary key vs. clustered index. I...

odd error message in function in a proc

By tcronin 95651

I have a cursor which has calls a function (sorry for  design this is...

How to make in memory SQL transformations within a data flow task

By svenflock

Hi all, first of all, I am new to Integration Services. I googled everything...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers