-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Gavin Draper's SQL Server Blog

Software Dev/DBA living the dream in sunny Brighton, UK. I've been playing with SQL Server about nearly 20 years now and still feel just as clueless as I did back then. I love writing about things I find as I go along.

Archives: June 2018

SQL Server How to Check What Settings Are Set On Active Sessions

SQL Server has a number of settings set on a session that can influence the behaviour or queries. When debugging issues, it’s often useful to be able to get a list of all user sessions and their current settings to check nothing specific to the session is causing odd behaviour.…

Read more

0 comments, 83 reads

Posted in Gavin Draper's SQL Server Blog on 1 June 2018

SQL Server How to Check What Settings Are Set On Active Sessions

SQL Server has a number of settings set on a session that can influence the behaviour or queries. When debugging issues, it’s often useful to be able to get a list of all user sessions and their current settings to check nothing specific to the session is causing odd behaviour.… Read more

0 comments, 94 reads

Posted in Gavin Draper's SQL Server Blog on 1 June 2018