To get the version info for the SQL server we use:
select @@version
or
select serverproperty('productversion')
Following are very cool links to get a very detailed information about all builds and versions which fairly helps in maintaining patches and security!
http://sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
http://sqlserverbuilds.blogspot.com/
http://support.microsoft.com/kb/321185
No comments:
Post a Comment