April 2008 - Posts

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

  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   Posted Apr 09 2008, 11:06 AM by jschlosser with no comments Filed under: SQL Server 2005

• CheckAsm - Assembly dependency viewer for .NET assemblies

  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/   Posted Apr 01 2008, 10:57 AM by jschlosser with no comments