Service Pack Question

[blue]

I have a MS SQL Server 2000 database that a customer of ours has sent to us
for testing purposes. Is there any way to tell what service pack this
database is at? A stored procedure of some kind that I can run on it?

Thank you,
Frank

[Vladimir]

determine MSSQL Service Pack.

u can either use global var @@version
by running
select @@version
-- result:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Standard Edition on Windows NT 5.2 (Build 3790 )

/* While the above global variable containst all needed information, it is hard to interpret it especially if you want to
determine the service pack number, the
SERVERPROPERTY (below) expression returns more useful and readable information (for MSSQL 2K only):
*/

SELECT SERVERPROPERTY( 'productversion '), SERVERPROPERTY ('productlevel' ), SERVERPROPERTY ('edition')

8.00.760 SP3 Standard Edition