devxlogo

February 23, 2005

Locate the Installed Version of MS SQL Server

This query: select @@version provides the following information: Version installed Service Pack installed Edition installed Here’s a sample of the output: Microsoft SQL Server 2000 – 8.00.194 (Intel X86) Aug