Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: August 2011

Get All SESSIONPROPERTY Values for Your Session

As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your current session in a table. Useful when you forget what the propertyname options are. Properties obtained from http://msdn.microsoft.com/en-us/library/ms175001.aspx.

DECLARE @props TABLE (propertyname sysname PRIMARY KEY)
INSERT

Read more

0 comments, 327 reads

Posted in Eric Humphrey on 23 August 2011

Dallas Tech Fest – Demo Files for SQL Server CLR: An Introduction

Demo files from my presentation at Dallas Tech Fest 2011.

 

SQL Server CLR – An Introduction – Dallas Tech Fest 2011

Read more

0 comments, 346 reads

Posted in Eric Humphrey on 12 August 2011