Just a day ago, while working on one of the project, I needed to see what is the two digit year cutoff of my current SQL Server. I did not remember what was the exact syntax to search for the same so I ran following query to list all server wide configurations. While looking at quickly I found out value of two digit year cutoff on line 19th. A small but very important script to save for getting server information.
I have ran this command on SQL Server 2008 and few of the information may be different than SQL Server 2005. When I ran this script I got 68 rows in result set.
I would like to know how many rows SQL Server 2005 returns.
Reference : Pinal Dave (http://blog.SQLAuthority.com)