How to find what version of SQL is running.
you can SELECT @@Version as in SQL 2000 to find the version of SQL Server.One more option would be is to use sp_server_info like
sp_server_info 500
Output
500 SYS_SPROC_VERSION 9.00.1399
So here is the tablw which represent what Service Pack has been appiled.
9.00.1399 for RTM( Release to Manufacturing)
9.00.2047 for SP1
9.00.3042 for SP2
No comments:
Post a Comment