Microsoft SQL Server version checking

Microsoft SQL Server version checking

You can run the following SQL Query to determine the running Version of SQL Server 2005: "SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')" 
Release	Sqlservr.exe
RTM	2005.90.1399
SQL Server 2005 Service Pack 1	2005.90.2047
SQL Server 2005 Service Pack 2	2005.90.3042
SQL Server 2005 Service Pack 3	2005.90.4035
If you get an error message that "Agent XPs" have not been enabled, you can execute these commands in the SQL Management Studio: You can enable Agent Xp's in sql server 2005. Run the below query in management studio to enable agent xp's. sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Agent XPs', 1; GO RECONFIGURE GO