Subscribe to this blog
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
0 comments, 195 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.
0 comments, 221 reads
Posted in Eric Humphrey on 12 August 2011