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 6 2000 00:57:48 Copyright (c) 1988-2000Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)