I am getting the following error when running the UMSSv540ps8L.sql script.
*** Verify SQL Server version Server: Msg 50000, Level 16, State 127, Line 24 *** ERROR *** Your server is at version Microsoft SQL Server 2008 (SP1. This script can only be run in SQL Server 2000 or 2005.
1. Open up the script and look for step A-02. Remove the following step:
- ********************************************
-- A-02) Verify current version of SQL Server
--
-- The below sql is used in the script to bypass code and exit unconditionally (if the #error table exists)
-- IF object_id('tempdb..#error') IS NOT NULL
-- RETURN
PRINT '*** Verify SQL Server version'
IF object_id('tempdb..#error') IS NOT NULL
DROP TABLE #error
DECLARE @SQL_Server_version varchar(30)
SELECT @SQL_Server_version = @@version
-- NOTE: double space before the 2000 is correct, single space for 2005
If @@version like 'Microsoft SQL Server 2000%' or @@version like 'Microsoft SQL Server 2005%'
RETURN -- Ok to run script
ELSE
CREATE TABLE #error(error INT)
--If @@version not like 'Microsoft SQL Server 2000%'
BEGIN
RAISERROR (N'*** ERROR *** Your server is at version %s. This script can only be run in SQL Server 2000 or 2005.', -- Message text
16, -- Severity
127, -- State 127 also causes OSQL to immediately exit
@SQL_Server_version) -- First substitution argument
WITH LOG;
RETURN
END
GO
-- ------------------------------------------------------------------------------------------------------------------
-- ------------------------------------------------------------------------------------------------------------------
-- Start of Query Batch ---------------------------------------------------------------------------------------------
IF object_id('tempdb..#error') IS NOT NULL
RETURN
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center