Microsoft SQL Server version checking

By donmc, 10 January, 2010

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