Tip: Reporting on Server Properties

The serverproperty(propertyname) function in SQL Server 2000 is a great resource for finding out which edition and which service pack of SQL Server you're running. You can use the serverproperty() function to report on any of the server properties that Figure A shows. SQL Server Books Online (BOL) has information about what serverproperty() reports for each of these properties. I'm especially fond of Edition and ProductLevel because they quickly show you which SQL Server edition and service pack you're running. The command