Monthly Archives: September 2009

Identifying SQL Server version information

Posted on by
1
How to identify SQL Server version information.
 
It couldn’t be much easier, really. Run the following T-SQL Script SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) 
 
For more information on the results it returns have a look at the following KB article ; http://support.microsoft.com/kb/321185

Converting Byte Arrays to Strings (C#)

Posted on by
Reply
It’s a lot easier than you think!
 
This is as much as a reminder to myslef as a helpful hint for other people. If you need to convert a byte array to a string the you can use the System.BitConverter class and the ToString() method which accepts a byte array as a parameter. For more information have a look at http://msdn.microsoft.com/en-us/library/system.bitconverter.aspx 
 
I used this for debugging SQL Server Timestamp columns so that I could get a more readable version of the column contents.