BgInfo from Sysinternals (now Windows Sysinternals, by Mark Russinovich) automatically displays relevant information about a Windows computer on the desktop's background, such as the computer name, IP address, service pack version, and more interesting f… more »

Related to previous post's, sometimes it is helpful to quickly determine SQL Server's service pack level. By selecting @@VERSION in a query window ...SELECT @@VERSION AS "SQL Server Version" you / I get following result: SQL Server Version Microsoft SQ… more »