When change management is not well implemented on the IT Department, some simple questions become hard to be answered immediately by system administrators, like :
- Which edition of SQL Server is installed ?
- What about the last Service Pack applied to the server ?
to answer this questions we can just execute a simple T-SQL query :
SELECT
ServerProperty('Edition'),
ServerProperty('ProductLevel'),
ServerProperty('ProductVersion')
the result of this query is :
The first column is Edition, the second is the service pack applied for the instance and the last represent the version number which can help us to determine if there are cumulative updates or security patch that was installed and changed the version number of the product. This information is very important because when you have to restore your system databases you will not be able to restore the master database if the version number of the saved master database is different from the version number of the installed server.
- The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released
- The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released
- The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released
- The SQL Server 2008 builds that were released after SQL Server 2008 was released
0 commentaires
Post a Comment