Julie Schlosser

SQL Server version and edition information - SERVERPROPERTY Function (SQL 2005)

jschlosser — Wed, 09 Apr 2008 16:06:00 GMT

I recently needed service pack and edition information for a SQL Server 2005 installation on a server I was working on. I figured I could get this information by simply using the Help --> About file menu option from within the Management Studio. No luck, this didn't give me edition and version information.

I was able to get this information by using the SERVERPROPERTY Function.

SELECT SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

For a complete list of properties that this function can return see: http://support.microsoft.com/kb/321185

For help using this function see: http://msdn2.microsoft.com/en-us/library/ms174396.aspx

CheckAsm - Assembly dependency viewer for .NET assemblies

jschlosser — Tue, 01 Apr 2008 15:57:00 GMT

We were recently troubleshooting an installation of a Windows Forms Application. We couldn't run the executable. We figured we were missing a dependent assembly, but didn't have a fast way to figure out which one. We came upon this great tool that quickly pointed us to the missing assembly. Not only did it help us to figure out which assembly we were missing, it helped us to determine which assemblies we were including that we didn't need to.

CheckAsm is very similar to Dependency Walker (depends.exe), but for .NET assemblies rather than system assemblies. It saved us a lot of time and is really easy to use. It is a great free tool.

http://checkasm.booring.net/