Method 1 Select ServerProperty ('ProductVersion') SELECT ServerProperty ('ProductLevel') method Two select @@ versionsionsql server 2000 version number 8.00.194 ------- SQL Server 2000 RTM 8.00.384 ------ - (SP1) 8.00.534 ------- (SP2) 8.00.760 ------- (SP3) can be used to see more detailed version information with XP_MSVER
