I recently encountered a problem where we had to identify the versions of SQL Running on a few servers. I found the quickest and easiest method was to run a SQL query against the servers in SQL Management studio. The SQL query to run is: SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) This will give you [...]
Archive for the ‘SQL 2008’ Category
SQL Server MP update – 6.0.6569.0
Posted: 1st April 2009 by neil in Managment Pack Updates, SQL 2008The SQL 2000, 2005, and 2008 MP’s have been updated. http://technet.microsoft.com/en-us/opsmgr/cc539535.aspx Changes in this release, from 6.0.6460.0: Fixed performance issues caused by excessive CPU utilization and script timeouts from Windows Management Instrumentation (WMI) queries in the following management pack discoveries: Discover SQL Server 2005 Database Engines (Windows Server), Discover SQL Server 2005 Reporting Services (Windows [...]
SQL 2008 RC0 released for Technet subscribers: http://technet.microsoft.com/en-us/subscriptions/downloads/details/default.aspx?pm=p:334