Thursday, September 27, 2007

Sql versions list

This is very important for every sql server DBA ।This version list will help disaster time.

select @@versions;
SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel'))
This command will return Returns:
'RTM' = shipping version.'SPn' = service pack version'Bn', = beta version.


http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

0 comments: