How to Know which Service Pak is currently installed on my SQL Server?

If you have SQL Server 2000, you can go to Enterprise Manager and property of your server to know the current level of Service Pak applied to your SQL Server installation. However, if you need to programmatically know the SQL Server version and the service Pak applied, you can check out this article!

Download PDF Document