2010-01-12
3,069 reads
2010-01-12
3,069 reads
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
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
Hello people, I am an SQL beginner and I have a problem with the...
Hello, I had an oddball question I was hoping someone could point me in...
Someone landed a PowerBI mess in my lap, and near as I can tell,...
How does the Resource database in SQL Server 2022 get backed up?
See possible answers