Session settings

External Article

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

The end of an era – why I chose not to renew my MVP

By

Two years ago, two things happened within a few days of each other. I...

PowerShell Strikes Back: A New Script

By

This is it. The final chapter of PowerShell Strikes Back. Over the past four...

Claude Desktop

By

Claude is more than a chat window. The desktop experience includes structured workspaces, generated...

Read the latest Blogs

Forums

Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Unraveling the Mysteries of the...

QUOTENAME Behavior

By Steve Jones - SSC Editor

Comments posted to this topic are about the item QUOTENAME Behavior

Running script without having permission to Function

By Reh23

Good Morning. I have a T-SQL Script which has been developed to execute a...

Visit the forum

Question of the Day

QUOTENAME Behavior

I use QUOTENAME() like this in code? 

DECLARE @s VARCHAR(20) = 'Steve Jones'
SELECT QUOTENAME(@s, '>')
What is returned?

See possible answers