Build Description Build Description Build Description Build Description SQL Server 2008 R2 Builds SQL Server 2008 R2 SP1 Builds SQL Server 2008 R2 SP2 Builds SQL Server 2008 R2 SP3 Builds
SELECT SERVERPROPERTY ( 'MachineName') AS, AS SQL and OS Version information for current instance (Query 1) (Version Info) Many of these queries may not work on this version.', 18, 16, N 'You have the correct major version of SQL Server for this diagnostic information script' RAISERROR ( 'Script does not match the ProductVersion of this instance. IF NOT EXISTS ( SELECT * WHERE CONVERT( varchar( 128), SERVERPROPERTY( 'ProductVersion')) LIKE '10.5%')ĭECLARE varchar( 128) = CONVERT( varchar( 128), SERVERPROPERTY( 'ProductVersion')) Check the major product version to see if it is SQL Server 2008 R2 Note: A number of these queries will only work on SQL Server 2008 R2 SP1 or later * TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A * ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED
#Sql 2008 r2 enterprise manager missing code#
* THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF * republish altered code as long as you include this copyright and give due credit. * You may alter this code for your own *non-commercial* purposes. Please make sure you are using the correct version of these diagnostic queries for your version of SQL Server Many of these queries will not work if you have databases in 80 compatibility mode SQL Server 2008 R2 Diagnostic Information Queries
0 kommentar(er)
