
/*
** Messages.SQL		1996/03/23 16:04
**
**    Please coordinate new range reservations through SQLEvent\SQLEvent.MC file!
**
** (From old InstMsgs.SQL)
**
** Copyright Microsoft, Inc. 1994, 1995, 1996
** All Rights Reserved.
** Use, duplication, or disclosure by the United States Government
** is subject to restrictions as set forth in subdivision (c) (1) (ii)
** of the Rights in Technical Data and Computer Software clause
** at CFR 252.227-7013. Microsoft, Inc. One Microsoft Way, Redmond WA
** 98052.
*/

/********  F I N D   L O W E S T   A V A I L A B L E   N U M B E R   I N   R A N G E

select    min(a_msg.error) + 1    -- Find gaps; Next lowest available number.
   from   master..sysmessages  a_msg
   where
         (a_msg.error + 1) between
               15000  and  15999  -- EDIT a work copy of this line !!
   and
          not exists
            (select      b_msg.error
               from      master..sysmessages  b_msg
               where     b_msg.error = (a_msg.error + 1)
            )

********/

go
DBCC TraceOff(3643)
go
use master
go
dump transaction master with no_log
go
checkpoint
go
set nocount on
set implicit_transactions off
go

declare @vdt varchar(99)
select  @vdt = convert(varchar,getdate(),113)
raiserror('Starting Install\Messages.SQL at  %s',0,1,@vdt) with nowait
go

print ''
print 'Making sure that updates to system tables are allowed.'
go

declare  @dbcc_current_version	integer
	,@int1			integer
dbcc getvalue('current_version')
select @dbcc_current_version = @@error

if (     exists (select * from sysobjects where name='sp_configure')
    AND  @dbcc_current_version = (select version from sysdatabases where name='master')
    AND  1 <> (select value from syscurconfigs where config = 102)
   )
	begin						--Query tree compatible
	exec @int1 = sp_configure 'allow updates',1
	if @@error <> 0 or @int1 <> 0
		raiserror('Bad sp_configure exec at top of Messages.SQL, killing spid.'
			,22,127) with log
	reconfigure with override
	end
go


/*
** Make sure server was started in single user mode or that sp_configure was used
** to enable updates to system tables.
*/
if (select value from syscurconfigs where config = 102) <> 1
	raiserror('
Cannot run Messages.SQL unless updates to system tables are enabled.
Shutdown server and restart with the ''-m'' option or use sp_configure
to enable updates to system tables.'
		,22,127) with log
go

dump transaction master with no_log
go

print ''
print 'Saving dlevel values in #temp table in case customer changed them.'
go

/*
** First save any user (looks like ALL, not just user?)
** set values in sysmessages.dlevel.
*/
SELECT
             error ,langid ,dlevel
      INTO
             #dsave
      from
             sysmessages --?! Perhaps work perm tb.
--    where
--           error   > 50000

go

print ' '

SELECT 'Num sysmessages rows Before big Delete:',count(*) from sysmessages
SELECT 'MIN/MAX(error) in sysmessages Before big Delete:',MIN(error) 'MIN_error',MAX(error) 'MAX_error' from sysmessages

go

print ''
print 'Deleting error messages that will be added, changed or are obsolete.'
go

set nocount off
go

DELETE from sysmessages
where error in
(
 102,114,116,118,125,130,142,146,153,170,177,188,194,216,221,227,232,260,268,269
,306,308,309,310,503,505,506,507,515,530,606,643,703,834,840,941

,1103,1118,1219,1520,1708,1709,1710,1914
,2517,2540,2566,2613,2627,2701,2711,2739,2811
,3008,3009,3205,3403,3406,3407,3437,3509,3609  ,4209,4210,4303,4304
,4510,4511,4602,4611,4612,4711,4712,4806,4814  ,5146, 5829, 5904, 6501
,7936, 8160, 7948

,13077,13078, 13079
)
	or error between   144 and   147
	or error between   423 and   440
	or error between   544 and   550
	or error between  1001 and  1030
	or error between  1110 and  1115
	or error between  1532 and  1538
	or error between  1750 and  1784
	or error between  2616 and  2618
	or error between  2744 and  2759
	or error between  3122 and  3125
	or error between  3211 and  3220
	or error between  3409 and  3411
	or error between  3612 and  3616
	or error between  3723 and  3735
	or error between  3909 and  3912
	or error between  4027 and  4044
	or error between  4317 and  4319
	or error between  4414 and  4426
	or error between  4912 and  4920
	or error between  5016 and  5018
	or error between  5148 and  5159
	or error between  5160 and  5167
	or error between  6201 and  6240
	or error between  7130 and  7139
	or error between  7964 and  7999
	or error between  8006 and  8007
	or error between  8101 and  8166
	or error between  8300 and  8305
	or error between  8400 and  8416
	or error between  8501 and  8524
	or error between 14001 and 14199
	or error between 14200 and 14299
	or error between 14300 and 14399
	or error between 14500 and 14599
	or error between 15000 and 15999
	or error between 16801 and 16999
go

set nocount on
go

print ' '

SELECT 'Num sysmessages rows After  big Delete:',count(*) from sysmessages
SELECT 'MIN/MAX(error) in sysmessages After  big Delete:',MIN(error) 'MIN_error',MAX(error) 'MAX_error' from sysmessages
go


print ''
print 'Adding system error messages.'
go

insert into sysmessages values
	(102,15,0,'Incorrect syntax near ''%.*s''.',NULL)
insert into sysmessages values
	(114,15,0,'Browse mode is invalid for a statement that assigns values to a variable.',NULL)
insert into sysmessages values
	(116,15,2,'Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.',NULL)
insert into sysmessages values
	(118,15,0,'Only System Administrator can specify %s option for %s command.',NULL)
insert into sysmessages values
	(125,15,2,'Case expressions may only be nested to level %d.',NULL)
insert into sysmessages values
	(130,16,0,'Cannot perform an aggregate function on an expression containing an aggregate or a subquery.',NULL)
insert into sysmessages values
	(142,15,0,'Incorrect syntax for definition of %s constraint.',NULL)
insert into sysmessages values
	(144,15,0,'Cannot use an aggregate or a subquery in an expression used for the by-list of a GROUP BY clause.',NULL)
insert into sysmessages values
	(145,15,0,'Order-by items must appear in the select-list if SELECT DISTINCT is specified.',NULL)
insert into sysmessages values
	(146,15,2,'Unable to allocate ancillary table for a subquery. Maximum number of tables in a query (%d) exceeded.',NULL)
insert into sysmessages values
	(147,15,0,'An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.',NULL)

go

insert into sysmessages values
	(153,15,2,'Invalid usage of the option ''%.*s'' in ''%s'' statement.',NULL)
insert into sysmessages values
	(170,15,0,'Line %d: Incorrect syntax near ''%.*s''.',NULL)
insert into sysmessages values
	(177,15,0,'The IDENTITY function can only be used when the SELECT statement has an INTO clause.',NULL)
insert into sysmessages values
	(188,15,0,'Can''t specify a log-device in a CREATE DATABASE statement without also specifying at least one non-log-device.',NULL)
insert into sysmessages values
	(194,15,0,'A SELECT INTO statement may not contain a SELECT statement that assigns values to a variable.',NULL)
insert into sysmessages values
	(216,16,1,'Attempt to drop temporary object(s) failed during cleanup processing.',NULL)
insert into sysmessages values
	(221,10,0,'FIPS Warning: Implicit conversion from %s to %s.',NULL)
insert into sysmessages values
	(227,16,0,'Maximum number of vector aggregates exceeded (%d max, %d found).',NULL)
insert into sysmessages values
	(232,16,0,'Arithmetic overflow error for type %s, value = %f.',NULL)
insert into sysmessages values
	(260,16,0,'Disallowed implicit conversion from datatype ''%s'' to datatype ''%s''%s  Table: ''%s'', Column: ''%s''%s  Use the CONVERT function to run this query.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid) values
	(268,16,0,'You cannot run SELECT INTO in this database.  The DBO would have to run sp_dboption to enable this option.',NULL)
insert into sysmessages values
	(269,16,0,'SETUSER with no name should be invoked from the database where the corresponding SETUSER with name was issued. Use database ''%.*s''.',NULL)
insert into sysmessages values
	(306,16,2,'TEXT and IMAGE datatypes may not be used in the WHERE or HAVING clause, except with the LIKE predicate and the IS NULL predicate.',NULL)
insert into sysmessages values
	(308,16,0,'Index ''%.*s'' on table ''%.*s'' (specified in the FROM clause) does not exist.',NULL)
insert into sysmessages values
	(309,16,2,'Unable to allocate ancillary table for reformatting. Maximum number of tables in a query (%d) exceeded.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid) values
	(310,16,0,'Invalid Escape sequence.  Valid characters after Esc are: an Esc pair, underbar, percent sign.',NULL)

go

insert into sysmessages values
	(423,16,0,'Too many substitution nodes in worktable. (MAX: %d, ACTUAL: %d). Try splitting query or limiting SELECT list.',NULL)
insert into sysmessages values
	(425,16,0,'Datatype ''%s'' of receiving variable not equal to datatype ''%s'' of column ''%.*s''.',NULL)
insert into sysmessages values
	(426,16, 0,'Length ''%d'' of receiving variable less than length ''%d'' of column ''%.*s''.',NULL)

go

go
dump transaction master with no_log
go


/*
** These are new messages for CONSTRAINT COMPILE
** Messages 424 - 440 (excluding 425, 426)
*/
insert into sysmessages values
	(424, 10, 0, '%s', NULL)
insert into sysmessages values
	(427, 20, 0, 'Unable to load SYSPROCEDURES entries for constraint id ''%d'' in dbid ''%d''.', NULL)
insert into sysmessages values
	(428, 20, 0, 'Unable find row in SYSCONSTRAINTS for constraint id ''%d'' in dbid ''%d''.', NULL)
insert into sysmessages values
	(429, 20, 0, 'Unable to find new constraint id ''%d'' in SYSCONSTRAINTS, dbid ''%d'' at compile time.', NULL)
insert into sysmessages values
	(430, 20, 0, 'Unable to resolve table name for object id ''%d'', dbid ''%d'' when compiling foreign key.', NULL)
insert into sysmessages values
	(431, 19, 0, 'Unable to bind foreign key constraint. Too many tables involved in query.', NULL)
insert into sysmessages values
	(432, 19, 0, 'Unable to bind work table for foreign key constraint. Too many tables involved in query.', NULL)
insert into sysmessages values
	(433, 20, 0, 'Unable to find CHECK constraint for ''%.*s'' though table is flagged as having one.', NULL)
insert into sysmessages values
	(434, 20, 0, 'Insert into worktable for variable ''%d'' for deferred constraint check failed.', NULL)
insert into sysmessages values
	(435, 20, 0, 'Unable to open referencing table id ''%d'' in dbid ''%d''.', NULL)
insert into sysmessages values
	(436, 20, 0, 'Unable to open referenced table id ''%d'' in dbid ''%d''.', NULL)
insert into sysmessages values
	(437, 20, 0, 'Unable to resolve the referenced column name in table id ''%d''.', NULL)
insert into sysmessages values
	(438, 20, 0, 'Unable to resolve the referencing column name in table id ''%d''.', NULL)
insert into sysmessages values
	(439, 20, 0, 'Unable to find foreign key constraints for table ''%.*s'' in dbid ''%d'' though table is flagged as having them.', NULL)
insert into sysmessages values
	(440, 20, 0, 'Unable to resolve column name for dbid ''%d'', object id, ''%d'',  column id ''%d'' in constraint ''%.*s''.', NULL)

go

insert into sysmessages values
	(503,16,0,'Stored procedure ''%.*s'' is a replication filter and cannot be executed.',NULL)

go

insert into sysmessages values
	(505,16,0,'Current user account was invoked with SETUSER. Changing databases is not allowed.',NULL)
insert into sysmessages values
	(506,16,0,'Invalid ESCAPE character ''%.*s'' has been specified in a LIKE clause.',NULL)
insert into sysmessages values
	(507,16,0,'Invalid argumemt %d specified for SET ROWCOUNT.',NULL)

insert into sysmessages values
	(515, 16, 2,'Attempt to insert the value NULL into column ''%.*s'', table ''%.*s''; column does not allow nulls.  %s fails.',NULL)
insert into sysmessages values
	(530, 16, 2,'Attempt to insert NULL value into column %d in work table (table id %ld); column does not allow NULLS.  %s fails.',NULL)

go

insert into sysmessages values
	(544,16,0,'Attempting to insert explicit value for identity column in table ''%.*s'' when IDENTITY_INSERT is set to OFF',NULL)
insert into sysmessages values
	(545,16,0,'Explicit value must be specified for identity column in table ''%.*s'' when IDENTITY_INSERT is set to ON',NULL)
insert into sysmessages values
	(546,16,0,'Identity value overflow for column ''%.*s'' while inserting into table ''%.*s''',NULL)
insert into sysmessages values
	(547,16,0,'%s statement conflicted with %s %s constraint ''%.*s''. The conflict occurred in database ''%.*s'', table ''%.*s''%s%.*s%s',NULL)
insert into sysmessages values
	(548,16,0,'attempt to perform direct %s to range that is maintained by replication. The conflict occurred in database ''%.*s'', table ''%.*s''%s%.*s%s',NULL)
insert into sysmessages values
	(549,16,0,'data exists in table ''%.*s'', database ''%.*s'', that violates %s constraint ''%.*s'' being added.  ALTER command has been aborted.', NULL)

go

insert into sysmessages values
	(550,16,2,
'The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view which specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.'
	,NULL)
insert into sysmessages values
	(606,16,0,'Error %d encountered while reading without locking, command is terminated.',NULL)
insert into sysmessages values
	(643,20,0,'Attempt to read page %d in database ''%.*s'' which is not allocated.',NULL)
insert into sysmessages values
	(834,21,2,'bufclean called on dirty buffer (page %#x, stat %#x/%#x, objid %#x, sstat%#x)',NULL)
insert into sysmessages values
	(840,17,1,'Device ''%.*s'' (with physical name ''%.*s'', and virtual device number %d) is not available.  Please contact System Administrator for assistance.',NULL)
insert into sysmessages values
	(941,14,1,'Database ''%.*s'' cannot be opened - it has not been upgraded to the latest format.  The SA can upgrade the database with SP_DB_UPGRADE procedure.',NULL)

go
dump transaction master with no_log
go

insert into sysmessages values
	(1001,16,2,'Line %d: Length or precision specification %d is invalid.',NULL)
insert into sysmessages values
	(1002,16,2,'Line %d: Specified scale %d is invalid.',NULL)
insert into sysmessages values
	(1003,15,0,'Line %d: %s clause allowed only for %s.',NULL)
insert into sysmessages values
	(1004,15,0,'Line %d: Use of %s not allowed; use %s.',NULL)
insert into sysmessages values
	(1005,15,0,'Line %d: Invalid procedure number (%d). Must be between 1 and 32767.',NULL)
insert into sysmessages values
	(1006,15,0,'CREATE TRIGGER contains no statements.',NULL)
insert into sysmessages values
	(1007,15,0,'The %S_MSG ''%.*s'' is out of the range for numeric representation (max precision: %d).',NULL)
insert into sysmessages values
	(1008,15,0,'The select list item identified by the order by number ''%d'' contains a variable as part of the expression that identifies a column position. Variables are only allowed when ordering by an expression referencing a column name.',
NULL)
go

insert into sysmessages (error ,severity ,dlevel ,description ,langid) values
	(1009,15,0,'Union all not allowed in INSERT statement',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid) values
	(1010,15,0,'Invalid Escape character ''%.*s''.',NULL)
insert into sysmessages values
	(1011,15,2,'The correlation name ''%.*s'' is specified multiple times in a FROM clause.',NULL)
insert into sysmessages values
	(1012,15,2,'The correlation name ''%.*s'' has the same exposed name as table ''%.*s''.',NULL)
insert into sysmessages values
	(1013,15,2,'Tables ''%.*s'' and ''%.*s'' have the same exposed names, use correlation names to distinguish them.',NULL)
insert into sysmessages values
	(1014,15,2,'The column prefix ''%.*s'' does not match with a table name or alias name used in the joined table specification.',NULL)
insert into sysmessages values
	(1015,15,2,'An aggregate may not appear in an ON clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.',NULL)
insert into sysmessages values
	(1016,15,2,'Outer join operators cannot be specified in a query containing joined tables.',NULL)
insert into sysmessages values
	(1017,15,2,'Joined tables cannot be specified in a query when trace flag 204 is on.',NULL)
insert into sysmessages values
	(1018,15,2,'Derived tables cannot be specified in a query when trace flag 204 is on.',NULL)
insert into sysmessages values
	(1019,15,0,'Invalid column list after object name in GRANT/REVOKE command.',NULL)
insert into sysmessages values
	(1020,15,0,'Column list cannot be specified for INSERT/DELETE/EXECUTE privileges in GRANT/REVOKE command.',NULL)
go

insert into sysmessages values
(1021,10,0,'FIPS Warning: Line %d: Non ANSI command ''%.*s''.',NULL)
insert into sysmessages values
(1022,10,0,'FIPS Warning: Line %d: Non ANSI clause ''%.*s''.',NULL)
insert into sysmessages values
(1023,15,0,'Invalid parameter %d specified for %s.',NULL)
insert into sysmessages values
(1024,10,0,'FIPS Warning: Line %d: Non ANSI function ''%.*s''.',NULL)
insert into sysmessages values
(1025,10,0,'FIPS Warning: Length of identifier ''%.*s'' exceeds 18.',NULL)
go
insert into sysmessages values
	(1026,15,2,'Neither CUBE nor ROLLUP can be specified in a query when trace flag 204 is on.',NULL)
insert into sysmessages values
	(1027,15,2,'Too many expressions specified in GROUP BY clause. The maximum number is %d when either CUBE or ROLLUP is specified.',NULL)
insert into sysmessages values
	(1028,15,2,'The CUBE and ROLLUP options are not allowed in a GROUP BY ALL clause.',NULL)
insert into sysmessages values
	(1029,15,0,'Browse mode is invalid for subqueries and derived tables.', NULL)
insert into sysmessages values
	(1030,15,0,'Union not allowed in INSERT query',NULL)
go

insert into sysmessages values
	(1103,21,0,'Allocation page %d in database ''%.*s'' has different segment id than that of the object to which we are allocating. Run DBCC CHECKALLOC.',NULL)
insert into sysmessages values
	(1110,20,0,'Attempt to resource lock allocation page %d in database ''%.*s'' by process %d while allocating to non-Syslogs object ''%.*s''.',NULL)
insert into sysmessages values
	(1111,20,0,'Extent bitmap on allocation page %d in database ''%.*s'' does not have extents marked that are being removed.',NULL)
insert into sysmessages values
	(1113,20,0,'Extent %d already locked while allocating it in database ''%.*s''.',NULL)
insert into sysmessages values
	(1114,20,0,'Attempt to resource lock page %d in database ''%.*s'' by process %d failed because lock is already held by process %d.',NULL)
insert into sysmessages values
	(1115,20,0,'Attempt to transfer a resource lock to process ID 0 on allocation page %d in database ''%.*s''.',NULL)
insert into sysmessages values
	(1118,17,0,'Database %.*s is full. Cannot allocate space for object %.*s.  All available pages are held by other transactions.  Try your command again.',NULL)
insert into sysmessages values
	(1219,16,0,'Deadlock: SPID %d Sequence %d Result %s',NULL)

insert into sysmessages values
	(1520,18,0,'Sort failed because dpages in the Sysindexes row for table ''%.*s'' in database ''%.*s'' had an incorrect value.  Please run DBCC CHECKTABLE on this table to correct the value, then re-run your commmand.',NULL)

insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(1532,20,0,'New sort run starting on page %x found extent not marked shared.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(1533,20,0,'Attempt to share extent %x among more than 8 sort runs.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(1534,20,0,'Extent %x not found in shared extent directory.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(1535,20,0,'Attempt to share extent %x found shared extent directory full.',NULL)

insert into sysmessages
	(error, severity, dlevel, description, langid)
        values
	(1536,20,0,'Attempt to build a non-clustered index on a memory-only work table.',NULL)

insert into sysmessages
	(error, severity, dlevel, description, langid)
        values
	(1537,20,0,'Attempt to suspend a sort not in row input phase.',NULL)

insert into sysmessages
	(error, severity, dlevel, description, langid)
        values
	(1538,20,0,'Attempt to insert into a sort not in row input phase.',NULL)

insert into sysmessages values
	(1708,15,0,'The total row size, %d, for table ''%.*s'' exceeds the maximum number of bytes per row, %d.',NULL)

go

/*
** These are new messages for ADD CONSTRAINT
** Messages 1750 - 1784
*/
insert into sysmessages values
	(1750, 10, 0, 'Unable to create constraint. See previous errors.', NULL)
insert into sysmessages values
	(1752, 16, 0, 'Unable to create DEFAULT for column ''%.*s'' as it is not a valid column in table ''%.*s''.', NULL)
insert into sysmessages values
	(1753, 16, 0, 'Column ''%.*s.%.*s'' is not of same length as referencing column ''%.*s.%.*s'' in foreign key ''%.*s''.', NULL)
insert into sysmessages values
	(1754, 16, 0, 'DEFAULTS cannot be created on columns with an IDENTITY attribute. Table ''%.*s'', column ''%.*s''.', NULL)
insert into sysmessages values
	(1755, 16, 0, 'DEFAULTS cannot be created on columns of type TIMESTAMP. Table ''%.*s'', column ''%.*s''.', NULL)
insert into sysmessages values
	(1756, 10, 0, 'Skipping foreign key constraint ''%.*s'' definition for temporary table.', NULL)
insert into sysmessages values
	(1757, 10, 0, 'Unable to create DEFAULT constraint. See previous errors.', NULL)
insert into sysmessages values
	(1758, 20, 0, 'Unable to update category field for ADD constraint.', NULL)
insert into sysmessages values
	(1759, 16, 0, 'Invalid column ''%.*s'' specified in constraint definition.', NULL)
insert into sysmessages values
	(1760, 16, 0, 'Constraints of type %s cannot be created on columns of type %s.', NULL)
insert into sysmessages values
	(1761, 16, 0, 'Foreign key ''%.*s'' references invalid database ''%.*s''.', NULL)
insert into sysmessages values
	(1762, 16, 0, '''%.*s'' is not a valid constraint.', NULL)
insert into sysmessages values
	(1763, 16, 0, 'Cross database foreign key references are not supported. Foreign key ''%.*s''.', NULL)
insert into sysmessages values
	(1764, 20, 0, 'Unable to update category field for %s table.', NULL)
insert into sysmessages values
	(1765, 20, 0, '%s', NULL)
insert into sysmessages values
	(1766, 16, 0, 'Foreign key references to temporary tables are not supported. Foreign key ''%.*s''.', NULL)
insert into sysmessages values
	(1767, 16, 0, 'Foreign key ''%.*s'' references invalid table ''%.*s''.', NULL)
insert into sysmessages values
	(1768, 16, 0, 'Foreign key ''%.*s'' references object ''%.*s'' which is not a user table.', NULL)
insert into sysmessages values
	(1769, 16, 0, 'Foreign key ''%.*s'' references invalid column ''%.*s'' in referencing table ''%.*s''.', NULL)
insert into sysmessages values
	(1770, 16, 0, 'Foreign key ''%.*s'' references invalid column ''%.*s'' in referenced table ''%.*s''.', NULL)
insert into sysmessages values
	(1771, 16, 0, 'Foreign key ''%.*s'' references object ''%.*s'' which is not a table.', NULL)
insert into sysmessages values
	(1772, 16, 0, 'Foreign key ''%.*s'' defines invalid relationship between a user table and system table.', NULL)
insert into sysmessages values
	(1773, 16, 0, 'Foreign key ''%.*s'' has implicit reference to object ''%.*s'' which does not have a PRIMARY KEY defined on it.', NULL)
insert into sysmessages values
	(1774, 16, 0, 'Number of columns in referencing column list for foreign key ''%.*s'' does not match those of the PRIMARY KEY in the referenced table ''%.*s''.', NULL)
insert into sysmessages values
	(1775, 16, 0, 'Number of columns in referencing column list for foreign key ''%.*s'' does not match those of the referenced key in the referenced table ''%.*s''.', NULL)
insert into sysmessages values
	(1776, 16, 0, 'There are no primary or candidate keys in the referenced table ''%.*s'' that match the referencing column list in the foreign key ''%.*s''.', NULL)
insert into sysmessages values
	(1777, 14, 0, 'User does not have correct permissions on referenced table ''%.*s'' to create foreign key ''%.*s''.', NULL)
insert into sysmessages values
	(1778, 16, 0, 'Column ''%.*s.%.*s'' is not of same type as referencing column ''%.*s.%.*s'' in foreign key ''%.*s''.', NULL)
insert into sysmessages values
	(1779, 16, 0, 'Table ''%.*s'' already has a PRIMARY KEY defined on it.', NULL)
insert into sysmessages values
	(1780, 20, 0, 'Could not find column ''%d'' in SYSCOLUMNS for object id ''%d'' in dbid ''%d''.', NULL)
insert into sysmessages values
	(1781, 16, 0, 'Column already has a DEFAULT bound to it.', NULL)
insert into sysmessages values
	(1782, 20, 0, 'Unable to update syscolumns to bind constraint based DEFAULT.', NULL)
insert into sysmessages values
	(1783, 20, 0, 'Unable to open table ''%s'' in dbid ''%d'' for constraint processing.', NULL)
insert into sysmessages values
	(1784, 20, 0, 'Unable to open system table ''%s'' in dbid ''%d'' for constraint processing. Ensure that this database has been correctly upgraded.', NULL)

go

insert into sysmessages values
	(1914,16,0,'Cannot create index on object ''%.*s'' because it is not a user table.',NULL)

go
dump transaction master with no_log
go


insert into sysmessages values
	(2517,16,0,'Table Corrupt: Procedure id %d (procedure name = %.*s) does not match between %.*s and %.*s',NULL)
insert into sysmessages values
	(2540,16,0,'Allocation Discrepancy: Page is allocated but not linked; check the following pages and ids: allocation pg#=%ld extent id=%ld logical pg#=%ld object id on extent=%ld (object name = %.*s) indid on extent=%ld',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid) values
	(2566,14,0,'DBCC DBREINDEX cannot be used on system tables.',NULL)
insert into sysmessages values
	(2613,20,0,'Attempt to remove resource lock on buffer holding logical page %d failed - the buffer was not resource locked.',NULL)
insert into sysmessages values
	(2616,20,0,'Buffer holding logical page %d cannot move to slot 1 since buffer holding logical page %d is already there.',NULL)
insert into sysmessages values
	(2617,20,0,'Buffer holding logical page %d not found in keep pool in SDES for object ''%.*s''',NULL)
insert into sysmessages values
	(2618,20,0,'Couldn''t find dupkey group starting at offset %d on page 0x%x.',NULL)
insert into sysmessages values
	(2627,14,0,'Violation of %s constraint ''%.*s'': Attempt to insert duplicate key in object ''%.*s''.',NULL)
insert into sysmessages values
	(2701,10,0,'Database name ''%.*s'' ignored, referencing object in Tempdb.',NULL)
insert into sysmessages values
	(2711,10,0,'Column or parameter #%d: -- ignoring column width on type ''%.*s''.',NULL)
insert into sysmessages values
	(2739,16,0,'TEXT and IMAGE datatypes are invalid for local variables.',NULL)
insert into sysmessages values
	(2744,16,0,'Multiple identity columns specified for table ''%.*s'', only one identity column per table',NULL)

go

/*
** New messages for user defined error support.
*/
insert into sysmessages values
	(2745,10,0,'Process %d has raised user error %d, severity %d. SQL Server is terminating this process.',NULL)
insert into sysmessages values
	(2746,16,0,'Cannot specify user error format string with length exceeding %d bytes.',NULL)
insert into sysmessages values
	(2747,16,0,'Too many substitution parameters for raiserror. Cannot exceed %d substitution parameters.',NULL)
insert into sysmessages values
	(2748,16,0,'Cannot specify %s datatype(raiserror parameter %d) as substitution parameter for raiserror.',NULL)

go

insert into sysmessages values
	(2749,16,2,'Identity column ''%.*s'' must be of type int, smallint, tinyint, decimal or numeric with scale of 0 and constrained to be non-nullable.',NULL)
insert into sysmessages values
	(2750,16,2,'Column or parameter #%d: -- specified column precision %d is greater than the maximum precision of %d.',NULL)
insert into sysmessages values
	(2751,16,2,'Column or parameter #%d: -- specified column scale %d is greater than the specified precision of %d.',NULL)
insert into sysmessages values
	(2752,16,2,'Identity column ''%.*s'' contains invalid SEED.',NULL)
insert into sysmessages values
	(2753,16,2,'Identity column ''%.*s'' contains invalid INCREMENT.',NULL)
insert into sysmessages values
	(2754,16,0,'Error severity greater than %d can be specified only by System Administrator by using the WITH LOG option.',NULL)
insert into sysmessages values
	(2755,16,0,'SET DEADLOCK_PRIORITY option ''%.*s'' is invalid.',NULL)
insert into sysmessages values
	(2756,16,0,'Invalid value %d for State; Valid range is from %d to %d.',NULL)
insert into sysmessages values
	(2757,16,0,'Raiserror failed due to invalid parameter substitution(s) for error %d, severity %d, state %d.',NULL)
insert into sysmessages values
	(2758,16,0,'%s could not locate entry for error %d in Sysmessages.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(2759,0,1,'Create schema failed due to previous errors.',NULL)

go

insert into sysmessages values
	(2811,18,0,'Cannot create procedure dbid %d, objid %d, with a group number of %d.',NULL)
insert into sysmessages values
	(3008,0,0,'Could not open the msdb.dbo.sysbackuphistory or sysrestorehistory table.  This probably indicates a problem with the setup of the msdb database.  DUMP/LOAD was still successful.',NULL)
insert into sysmessages values
	(3009,0,0,'Could not insert a backup or restore history/detail record in msdb.dbo.sysbackuphistory or sysrestorehistory. This may indicate a problem with the MSDB database.  DUMP/LOAD was still successful.',NULL)
insert into sysmessages values
	(3122,16,0,'This master database dump was created from a 4.2x server and cannot be loaded.',NULL)
insert into sysmessages values
	(3123,16,0,'Multipart database names (''%.*s'') are illegal for LOAD DATABASE.',NULL)
go
insert into sysmessages values
	(3124,16,0,'Must be an System Administrator to perform LOAD HEADERONLY.',NULL)
insert into sysmessages values
	(3125,16,0,'No devices specified for LOAD HEADERONLY.',NULL)
go

insert into sysmessages values
	(3205,16,0,'Too many dump devices specified for dump/load; only %d allowed.',NULL)
go

insert into sysmessages values
	(3211,10,0,'%d percent %s',NULL)
insert into sysmessages values
	(3212,16,0,'The load requires %d dump devices and %d have been specified.',NULL)
insert into sysmessages values
	(3213,10,0,'%d volume(s) of the current stripe set have been read; Mount the next %d volume(s).',NULL)
insert into sysmessages values
	(3214,16,0,'The volume on %.*s does not belong to the current stripe set.',NULL)
insert into sysmessages values
	(3215,16,0,'Number of stripe dump devices(%d) can be at most one more than the system config parameter ''backup threads'' (%d); reconfigure ''backup threads'' to be at least %d, and restart the server to try again.',NULL)
go

insert into sysmessages values
	(3216,16,0,'%s expects ''%s'' type; ''%s'' type has been specified and is invalid.',NULL)
insert into sysmessages values
	(3217,16,0,'Invalid value ''%s'' specified for %s.',NULL)
go

insert into sysmessages values
	(3218,16,0,'Dump was done from a server with Processor type %d and cannot be loaded in a server with Processor type %d.',NULL)
insert into sysmessages values
	(3219,16,0,'The stripeset tape in device ''%.*s'' has already been loaded.',NULL)
insert into sysmessages values
	(3220,16,0,'Page ''%ld'' of database ''%.*s'' in the database has the PG_DMPTRLR bit set.',NULL)
go

insert into sysmessages values
	(3403,22,0,'Rec_init: Found that page %d had non-log object id %d while checking  Syslogs allocation.',NULL)
go

insert into sysmessages values
	(3406,10,2,'%d transactions rolled forward in dbid %d.',NULL)
insert into sysmessages values
	(3407,10,2,'%d transactions rolled back in dbid %d.', NULL)

insert into sysmessages values
	(3409,10,2,'Roll forward transaction ''%.*s'' in dbid %d.', NULL)
insert into sysmessages values
	(3410,10,2,'Roll back transaction ''%.*s'' -- was aborted in dbid %d.', NULL)
insert into sysmessages values
	(3411,10,2,'Roll back transaction ''%.*s'' -- no ''end transaction'' in dbid %d.', NULL)

insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(3437,21,1,'Error recovering database ''%.*s'' - could not connect to the DTC to check completion status of xact: %S_RID',NULL)
go

insert into sysmessages values
	(3509,14,1,'Attempt to set database ''%.*s'' to read only user mode failed because transaction %d:%d is active.  Make sure that no other users are currently using this database and rerun CHECKPOINT.',NULL)
go

insert into sysmessages values
	(3609,10,0,'Attempt to update a column in the fabricated row of an inner table in an outer join.', NULL)
insert into sysmessages values
	(3612, 10, 0,
	'%sSQL Server Execution Times:%s   cpu time = %lu ms.  elapsed time = %lu ms.',
	NULL)
insert into sysmessages values
	(3613, 10, 0,
	'SQL Server Parse and Compile Time:%s   cpu time = %lu ms.', NULL)
insert into sysmessages values
	(3615,10,0,'Table: %.*s  scan count %d,  logical reads: %d,  physical reads: %d,  read ahead reads: %d',NULL)
insert into sysmessages values
	(3616,22,0,'Non-leaf page %d in table %d, index %d is empty - please rebuild the index.',NULL)
go

/*
** These are new messages for DROP CONSTRAINT (and one for replication)
** Messages 3723 - 3735
*/
insert into sysmessages values
	(3723,16,0,'Explicit DROP INDEX not allowed on index ''%.*s''. It is being used for %s constraint enforcement.', NULL)
insert into sysmessages values
	(3724,16,0,'Cannot drop the %S_MSG ''%.*s'' because it is published for replication.', NULL)
insert into sysmessages values
	(3725, 16, 0, 'Constraint ''%.*s'' is being referenced by table ''%.*s'', foreign key constraint ''%.*s''.', NULL)
insert into sysmessages values
	(3726, 16, 0, 'Could not drop object ''%.*s''.  It is being referenced by a foreign key constraint.', NULL)
insert into sysmessages values
	(3727, 10, 0, 'Unable to drop constraint. See previous errors.', NULL)
insert into sysmessages values
	(3728, 16, 0, '''%.*s'' is not a constraint.', NULL)
insert into sysmessages values
	(3729, 20, 0, 'Unable to open table ''%.*s'' in dbid ''%d''.', NULL)
insert into sysmessages values
	(3730, 20, 0, 'Unable to locate entry in %s for constraint ''%.*s''.', NULL)
insert into sysmessages values
	(3731, 16, 0, '''%.*s'' is not a valid object.', NULL)
insert into sysmessages values
	(3732, 10, 0, '%s', NULL)
insert into sysmessages values
	(3733, 16, 0, 'Constraint ''%.*s'' does not belong to table ''%.*s''.', NULL)
insert into sysmessages values
	(3734, 20, 0, 'Unable to update category field for DROP constraint.', NULL)
insert into sysmessages values
	(3735, 20, 0, 'Primary key or unique constraint ''%.*s'' returned invalid indid:%d from sysconstraints.', NULL)
go

/*
** The following are new messages for bound session support.
** Messages 3909 - 3912
*/
insert into sysmessages values
	(3909, 16, 0, 'Session binding token is invalid or corrupt.', NULL)
insert into sysmessages values
	(3910, 16, 0, 'Transaction context in use by another session.', NULL)
insert into sysmessages values
	(3911, 16, 0, 'Aborted active transaction on unreferenced bound session.', NULL)
insert into sysmessages values
	(3912, 16, 0, 'Attempt to bind using an XP token while the server is not in an XP call.', NULL)
go

go
dump transaction master with no_log
go


/*
** These are new messages for tape devices
** Messages 4027 - 4035
*/
insert into sysmessages values
	(4027,16,0,'Mount tape for %s of database ''%s''.',NULL)
insert into sysmessages values
	(4028,10,0,'End of tape has been reached, remove tape ''%s'' and mount next tape for %s of database ''%s''.',NULL)
insert into sysmessages values
	(4029,10,0,'Database ''%s''%s(%d pages) dumped to file <%d> on tape ''%s''.',NULL)
insert into sysmessages	values
	(4030,16,0,'Tape ''%s'' expires on day ''%s'' year ''%s'' and cannot be overwritten.',NULL)
insert into sysmessages values
	(4031,16,0,'Creation date on tape ''%s''(%s) does not match that of first volume(%s).',NULL)
insert into sysmessages values
	(4032,16,0,'Cannot find file %d on tape ''%s''.',NULL)
insert into sysmessages values
	(4033,16,0,'File <%d> on tape ''%s'' is not a SQL Server %s dump.',NULL)
insert into sysmessages values
	(4034,16,0,'Warning, file <%d> on tape ''%s'' was dumped from database ''%s''.',NULL)
insert into sysmessages	values
	(4035,10,0,'Database ''%s''%s(%d pages) dumped to file <%d> on device ''%s''.',NULL)
insert into sysmessages values
	(4036,16,2, 'Diskdump ''%s'' expires on day ''%s'' year ''%s'' and cannot be overwritten.',NULL)
insert into sysmessages values
	(4037,16,0,'User specified volume id ''%s'' does not match the volume id ''%s'' of the device ''%.*s''.',NULL)
go

insert into sysmessages values
	(4038,16,0,'Cannot find file %d on device ''%s''.', NULL)
insert into sysmessages values
	(4039,10,0,'Warning, file <%d> on device ''%s'' was dumped from database ''%s''.',NULL)
insert into sysmessages values
	(4040,16,0,'File <%d> on device ''%s'' is not a SQL Server %s dump.',NULL)
insert into sysmessages values
	(4041,16,0,'Device ''%s'' has a stripe volume version; use INIT option for non-stripe dumps.',NULL)
insert into sysmessages values
	(4042,16,0,'Device ''%s'' has a non stripe volume version; use INIT option for stripe dumps.',NULL)
insert into sysmessages values
	(4043,16,0,'Device ''%.*s'' has file number mismatch <%d> with stripe file number <%d>.',NULL)
insert into sysmessages values
	(4044,10,0,'Warning: EXPIREDATE or RETAINDAYS is enforced only for the first dump in the volume.',NULL)
go

insert into sysmessages values
	(4209,16,2,'DUMP TRANsaction is not allowed because log was truncated or DUMP DATABASE was never run.  Must run DUMP DATABASE.',NULL)
insert into sysmessages values
	(4210,16,0,'While attempting DUMP TRANsaction WITH NO_TRUNCATE, couldn''t find database %.*s.',NULL)
go

insert into sysmessages values
	(4303,16,0,'LOAD TRANSACTION has been interrupted by a USER ATTENTION signal. Must restart load sequence with the load database to continue.',NULL)
insert into sysmessages values
	(4304,16,0,'USER ATTENTION signal raised during LOAD TRANSACTION is being ignored till the completion of current load.',NULL)
go

insert into sysmessages values
	(4317,16,0,'Multipart database names (''%.*s'') are illegal for LOAD TRANSACTION.',NULL)
go

/* Backup/restore messages */

insert into sysmessages values
	(4318, 16, 2, 'Database name must be specified', NULL)
insert into sysmessages values
	(4319, 16, 2, 'Owner name and Table name must both be specified', NULL)
go

insert into sysmessages values
	(4414,16,2,'Unable to allocate ancillary table for view resolution. Maximum number of tables in a query (%d) exceeded.',NULL)
insert into sysmessages values
	(4415,16,2,'View ''%.*s'' is not updatable because either it was created WITH CHECK OPTION or it spans a view created WITH CHECK OPTION and the target table is referenced multiple times in the resultant query.',NULL)
insert into sysmessages values
	(4416,16,0,'View ''%.*s'' is not updatable because the definition contains a set operator.', NULL)
insert into sysmessages values
	(4417,16,0,'Derived table ''%.*s'' is not updatable because the definition contains a set operator.', NULL)
insert into sysmessages values
	(4418,16,0,'Derived table ''%.*s'' is not updatable because it contains aggregates.', NULL)
insert into sysmessages values
	(4419,16,0,'Derived table ''%.*s'' is not updatable because the definition contains DISTINCT.', NULL)
insert into sysmessages values
	(4420,16,0,'Derived table ''%.*s'' is not updatable because the FROM clause names multiple tables.', NULL)
insert into sysmessages values
	(4421,16,0,'Derived table ''%.*s'' is not updatable because a field of the derived table is derived or constant.', NULL)
insert into sysmessages values
	(4422,16,0,'View ''%.*s'' contains joined tables which cannot be specified in a query when trace flag 204 is on.',NULL)
insert into sysmessages values
	(4423,16,0,'View ''%.*s'' contains derived tables which cannot be specified in a query when trace flag 204 is on.',NULL)
insert into sysmessages values
	(4424,16,0,'Joined tables cannot be specified in a query containing outer join operators. View ''%.*s'' contains joined tables.',NULL)
insert into sysmessages values
	(4425,16,0,'Outer join operators cannot be specified in a query containing joined tables. View ''%.*s'' contains outer join operators.',NULL)
insert into sysmessages values
	(4426,16,0,'View ''%.*s'' contains a CUBE or ROLLUP option which cannot be specified in a query when trace flag 204 is on.',NULL)
insert into sysmessages values
	(4510,16,2,'Create view failed because WITH CHECK OPTION was specified and the view is not updatable.',NULL)
insert into sysmessages values
	(4511,16,0,'Create view failed because no column name was specified for column %d.',NULL)
go

insert into sysmessages values
	(4602,14,0,'Only the System Administrator may GRANT or REVOKE the CREATE DATABASE permission.',NULL)
insert into sysmessages values
	(4611,16,0,'To revoke grantable privileges specify the CASCADE option with revoke.',NULL)
insert into sysmessages values
	(4612,16,0, 'You cannot grant privileges with grant option to groups or PUBLIC.', NULL)

go

insert into sysmessages values
	(4711,16,0,'Cannot truncate table ''%.*s'' because it is published for replication.',NULL)
insert into sysmessages values
	(4712,16,0,'Cannot truncate table ''%.*s'' because it is being referenced by a foreign key constraint.',NULL)
go

insert into sysmessages values
	(4806,10,1,'Warning, reverting to slow bulk copy on table ''%.*s'' because BULKCOPY option not set in database ''%.*s''.',NULL)
insert into sysmessages values
	(4814,16,0,'Cannot perform an unlogged bulk copy into table ''%.*s'' because it is published for replication.',NULL)
go

/*
** These are new messages for alter table
** Messages 4912 - 4915
*/
insert into sysmessages values
	(4912,16,0,'The alter table statement contains multiple identity columns, alter table ''%.*s'' failed',NULL)
insert into sysmessages values
	(4913,16,0,'Table ''%.*s'' already contains an identity column, cannot add new identity column via alter table',NULL)
insert into sysmessages values
	(4914,16,0,'The number of existing rows (%ld) exceeds the maximum value for the specified datatype, cannot add new identity column to ''%.*s''',NULL)
insert into sysmessages values
	(4915,16,0,'Maximum row width exceeded when adding identity column ''%.*s'' to table ''%.*s''',NULL)
insert into sysmessages values
	(4916,16,0,'Unable to enable or disable the constraint.  See previous errors.', NULL)
insert into sysmessages values
	(4917,16,0,'Constraint ''%.*s'' does not exist.', NULL)
insert into sysmessages values
	(4918,16,0,'Unable to locate entry in SYSCONSTRAINTS for constraint ''%.*s''.',NULL)
insert into sysmessages values
	(4919,16,0,'User does not have privilages to enable or disable constraint ''%.*s''.',NULL)

go
dump transaction master with no_log
go


insert into sysmessages values
	(5016,16,0,'Incorrect database name or device name(s).',NULL)

insert into sysmessages values
	(5017,16,0,'ALTER DATABASE failed.  Database %.*s not created with ''for load'' option.',NULL)
go

insert into sysmessages values
	(5018,16,1, 'The size of tempdb in RAM has exceeded the limit. The sum of ''memory size'' and ''tempdb in ram'' (configurable options) cannot exceed 2046 Megs.',NULL)
go


insert into sysmessages values
	(5146,16,0,'The %s of %d is out of range.  It must be between %d and %d.',NULL)
go

/* New messages for expanding devices. */
insert into sysmessages values
	(5148,16,0,'Disk Resize can be used only to expand non-RAM devices.',NULL)
insert into sysmessages values
	(5149,16,0,'Disk Resize encountered an error while attempting to expand the physical file. Please consult the SQL Server error log for more details',NULL)
go

/*
** These are the new messages for DBCC DEVCONTROL (5150-5159)
*/
insert into sysmessages values
	(5150,16,0,'Cannot find device ''%.*s'' in sysdevices.',NULL)
insert into sysmessages values
	(5151,16,0,'Cannot explicitly open or close the master device.',NULL)
insert into sysmessages values
	(5152,16,0,'Failed to close device ''%.*s'', see errorlog for details.',NULL)
insert into sysmessages values
	(5153,16,0,'Failed to open device ''%.*s'', see errorlog for details.',NULL)
insert into sysmessages values
	(5154,16,0,'Device ''%.*s'' is not open.',NULL)
insert into sysmessages values
	(5155,16,0,'Device ''%.*s'' is already open.',NULL)
insert into sysmessages values
	(5156,16,0,'Usage: DBCC DEVCONTROL(devname,ONLINE|OFFLINE)',NULL)
insert into sysmessages values
        (5157,16,0,'IO error in writelog during backout.',NULL)
insert into sysmessages values
        (5158,10,0,'Warning, media in device ''%.*s'' may have been changed.',NULL)
insert into sysmessages values
        (5159,16,0,'OS Error %.*s on device ''%.*s'' during %s',NULL)
go

/*
** These are the new messages for DBCC DBCONTROL (5160-5167)
*/
insert sysmessages values
	(5160,16,0,'Cannot take ''%.*s'' offline because usecount=%d.',NULL)
insert sysmessages values
	(5161, 1,1,'Database ''%.*s'' is now marked offline.',NULL)
insert sysmessages values
	(5162,16,0,'Cannot find ''%.*s'' in sysdatabases.',NULL)
insert sysmessages values
	(5163,16,0,'Cannot open ''%.*s'' to take offline.',NULL)
insert sysmessages values
	(5164,16,0,'Usage: DBCC DBCONTROL(dbname,ONLINE|OFFLINE)',NULL)
insert sysmessages values
	(5165,16,0,'Cannot explicitly open or close master database.',NULL)
insert sysmessages values
	(5166,16,0,'Database ''%.*s'' is not offline.',NULL)
insert sysmessages values
	(5167,16,0,'Database ''%.*s'' is already offline.',NULL)
go

insert sysmessages values
	(5829,16,0,'Specified user options value is invalid.',NULL)
go
insert into sysmessages values
	(5904,17,0,'Background checkpoint process suspended until locks are available.',NULL)
go

insert into sysmessages values
	(6201,10,0,'STEP %d',NULL)
insert into sysmessages values
	(6202,10,0,'The type of query is SELECT (into a worktable)',NULL)
insert into sysmessages values
	(6203,10,0,'The type of query is %s',NULL)
insert into sysmessages values
	(6204,10,0,'The update mode is direct',NULL)
insert into sysmessages values
	(6205,10,0,'The update mode is deferred',NULL)
insert into sysmessages values /* Changed */
	(6206,10,0,'%*sGROUP BY',NULL)
insert into sysmessages values   /* Changed */
	(6207,10,0,'%*sVector Aggregate',NULL)
insert into sysmessages values
	(6208,10,0,'Scalar Aggregate',NULL)
insert into sysmessages values
	(6209,10,0,'This step involves sorting',NULL)
insert into sysmessages values
	(6210,10,0,'Worktable created for ORDER BY',NULL)
insert into sysmessages values
	(6211,10,0,'Worktable created for DISTINCT',NULL)
insert into sysmessages values
	(6212,10,0,'Worktable created for REFORMATTING',NULL)
insert into sysmessages values
	(6213,10,0,'Worktable created for SELECT INTO',NULL)
insert into sysmessages values
	(6214,10,0,'%*sTO TABLE',NULL)
insert into sysmessages values
	(6215,10,0,'%*sFROM TABLE',NULL)
insert into sysmessages values
	(6216,10,0,'%*sWorktable %d',NULL)
insert into sysmessages values
	(6217,10,0,'%*s%.*s %.*s',NULL)
insert into sysmessages values
	(6219,10,0,'%*sNested iteration',NULL)
insert into sysmessages values
	(6220,10,0,'%*sEXISTS : nested iteration',NULL)
insert into sysmessages values
	(6221,10,0,'%*sUsing GETSORTED Table Scan',NULL)
insert into sysmessages values
	(6222,10,0,'%*sUsing Dynamic Index',NULL)
insert into sysmessages values
	(6223,10,0,'%*sTable Scan',NULL)
insert into sysmessages values
	(6224,10,0,'%*sUsing Clustered Index',NULL)
insert into sysmessages values
	(6225,10,0,'%*sIndex : %.*s',NULL)
insert into sysmessages values
	(6226,10,0,'%*sIndex name not found',NULL)
insert into sysmessages values
	(6227,10,0,'%*sSUBQUERY : nested iteration',NULL)
insert into sysmessages values
	(6228,10,0,'%*sAND EXISTS : nested iteration',NULL)
insert into sysmessages values
	(6229,10,0,'%*sOR EXISTS : nested iteration',NULL)
insert into sysmessages values
	(6230,10,0,'%*sNOT EXISTS : nested iteration',NULL)
insert into sysmessages values
	(6231,10,0,'%*sCONSTRAINT : nested iteration',NULL)
insert into sysmessages values
	(6232,10,0,'%*sRow estimate:  %s',NULL)
insert into sysmessages values
	(6233,10,0,'%*sCost estimate: %s',NULL)
insert into sysmessages values
	(6234,10,0,'%*sJOINS WITH',NULL)
insert into sysmessages values
	(6235,10,0,'WITH CHECK OPTION',NULL)
insert into sysmessages values
	(6236,10,0,'%*sLEFT OUTER JOIN : nested iteration',NULL)
insert into sysmessages values
	(6237,10,0,'%*sFULL OUTER JOIN : nested iteration',NULL)
insert into sysmessages values
	(6238,10,0,'%*sUNION ALL',NULL)
insert into sysmessages values
	(6239,10,0,'%*sGROUP BY WITH ROLLUP',NULL)
insert into sysmessages values
	(6240,10,0,'%*sGROUP BY WITH CUBE',NULL)
go

insert into sysmessages values
	(6501,21,0,'Logical page 0x%x in database ''%.*s'' missing from buffer cache after fetching the index row.',NULL)
insert into sysmessages values
	(7130,16,0,'%s with no log is not valid at this time. Use sp_dboption to set the ''select into/bulk copy'' option on for database %s.',NULL)
go
insert into sysmessages values
	(7133,16,0,'NULL textptr passed to %s function.',NULL)
insert into sysmessages values
	(7135,16,0,'Deletion length %ld is not in the range of available text data',NULL)
insert into sysmessages values
	(7136,16,0,'%s with no log is not valid when the column is being replicated.',NULL)
insert into sysmessages values
	(7137,16,0,'%s is not allow because the column is being replicated to a non-SQL Server subscriber.',NULL)
insert into sysmessages values
        (7138,16,0,'Text data created by the CONVERT() function can not be stored in work tables at this time.',NULL)
insert into sysmessages values
        (7139,16,0,'Length of text data ( %ld ) to be replicated exceeds configured maximum: %ld.',NULL)
insert into sysmessages values
	(7936, 16, 0,'%s index ''%.*s'' is being rebuilt.',NULL)
insert into sysmessages values
	(7948, 16, 0,'Server must be started in single user mode to shrink database ''%.*s''.',NULL)
insert into sysmessages values
	(7964,16,0,'Allocation page SDES not open.',NULL)
insert into sysmessages values
	(7965,16,0,'Page is not an allocation page.',NULL)
insert into sysmessages values
	(7966,10,0,'WARNING: NOINDEX option of ''%.*s'' being used, checks on non-system indexes will be skipped',NULL)
insert into sysmessages values
	(7967,16,2,'DBCC %.*s command does not support the %.*s option.',NULL)
insert into sysmessages values
	(7968,1,1,'Transaction Information for database: %.*s',NULL)
insert into sysmessages values
	(7969,1,1,'    No active open transactions.',NULL)
insert into sysmessages values
	(7970,1,1,'%sOldest active transaction:',NULL)
insert into sysmessages values
	(7971,1,1,'        SPID          : %d',NULL)
insert into sysmessages values
	(7972,1,1,'        UID           : %d',NULL)
insert into sysmessages values
	(7973,1,1,'        SUID          : %d',NULL)
insert into sysmessages values
	(7974,1,1,'        Name          : %.*s',NULL)
insert into sysmessages values
	(7975,1,1,'        RID           : (%d , %d)',NULL)
insert into sysmessages values
	(7976,1,1,'        Time Stamp    : %04X %08X',NULL)
insert into sysmessages values
	(7977,1,1,'        Start Time    : %.*s',NULL)
insert into sysmessages values
	(7979,1,1,'%sReplicated Transaction Information:',NULL)
insert into sysmessages values
	(7980,1,1,'        Oldest Distributed RID     : (%d , %d)',NULL)
insert into sysmessages values
	(7981,1,1,'        Time Stamp                 : %04X %08X',NULL)
insert into sysmessages values
	(7982,1,1,'        Oldest Non-Distributed RID : (%d , %d)',NULL)
insert into sysmessages values
	(7983,14,1,'Only the DBO of database %.*s may run the DBCC %s command',NULL)
go
insert into sysmessages values
	(7984,16,1,'Invalid object name ''%.*s''.',NULL)
insert into sysmessages values
	(7985,16,1,'The object name ''%.*s'' contains more than the maximum number of prefixes. The maximum is %d.',NULL)
insert into sysmessages values
	(7986,16,1,'WARNING: Pinning tables should be carefully considered. If a pinned table is larger or grows larger than the available data cache, the server may need to be restarted and the table unpinned.',NULL)
insert into sysmessages values
	(7987,16,1,'Switch to database ''%.*s'' before running this command.', NULL)
insert into sysmessages values
	(7988,16,1,'This command cannot be run on the MASTER database when a size parameter is specified. Use the ''%s'' option.', NULL)
insert into sysmessages values
	(7989,16,1,'The size option cannot be specified for TEMPDB when it is on a RAM device.', NULL)
insert into sysmessages values
	(7990,16,1,'Database ''%.*s'' has status: 0x%x which is not a normal database state. (Mask: 0x%x).', NULL)
insert into sysmessages values
	(7991,16,1,'Unable to shrink database ''%.*s'' as it contains %d pages. Minimum pages %d.', NULL)
insert into sysmessages values
	(7992,10,1,'DBCC SHRINKDB running on database ''%.*s''...', NULL)
insert into sysmessages values
	(7993,16,1,'Unable to shrink database ''%.*s'' to %d pages as it only contains %d pages.', NULL)
insert into sysmessages values
	(7994,16,1,'Unable to shrink database ''%.*s'' to %d pages. Minimum new size %d pages.', NULL)
insert into sysmessages values
	(7995,16,1,'See prior errors. DBCC operation has been aborted.', NULL)
insert into sysmessages values
	(7996,16,1,'Extended stored procedures can only be created in the master database.', NULL)
go

insert into sysmessages values
	(7997,16,1, '''%.*s'' does not contain an identity column.', NULL)
insert into sysmessages values
	(7998,16,1, 'Checking identity information: current identity value ''%.*s'', current column value ''%.*s''.', NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid) values
	(7999,16,0,'Could not find any index named ''%.*s'' for table ''%.*s''.',NULL)

go
dump transaction master with no_log
go

insert sysmessages values
	(8006,16,0,'Maxlen %d invalid for datatype ''%s''.',NULL)
insert into sysmessages values
	(8007,16,0,'Invalid server-to-server rpc parameter (position %d, name %s, type %s)',NULL)
insert into sysmessages values
	(8101,16,0,'An explicit value for the identity column in table ''%.*s'' can only be specified when a column list is used and IDENTITY_INSERT is ON',NULL)
insert into sysmessages values
	(8102,16,0,'Illegal attempt to update identity column ''%.*s''',NULL)
insert into sysmessages values
	(8103,16,0,'Table ''%.*s'' does not exist or cannot be opened for SET operation',NULL)
insert into sysmessages values
	(8104,16,0,'Current user is not the DBO or object owner for table ''%.*s'', unable to perform SET operation',NULL)
insert into sysmessages values
	(8105,16,0,'''%.*s'' is not a user table, unable to perform SET operation',NULL)
insert into sysmessages values
	(8106,16,0,'Table ''%.*s'' does not have the identity property, unable to perform SET operation',NULL)
insert into sysmessages values
	(8107,16,0,'IDENTITY_INSERT is already ON for table ''%.*s.%.*s.%.*s''.%sUnable to perform SET operation for table ''%.*s''.',NULL)
insert into sysmessages values
	(8108,16,0,'Attempting to add identity column to table ''%.*s'', via select into, which already has column ''%.*s'' that inherits the identity property.',NULL)
insert into sysmessages values
	(8109,16,0,'Attempting to add multiple identity columns to table ''%.*s'', via select into.',NULL)
insert into sysmessages values
	(8110,16,0,'Attempting to add multiple primary key constraints to table ''%.*s''.',NULL)
insert into sysmessages values
	(8111,16,0,'Attempting to define PRIMARY KEY constraint on nullable column in table ''%.*s''.',NULL)
insert into sysmessages values
	(8112,16,0,'Attempting to add more than one clustered index for constraints on table ''%.*s''.',NULL)
insert into sysmessages values
	(8113,16,0,'Unable to recompile ''%.*s'', ''%s %.*s'' is illegal in an open transaction.',NULL)
go

/*
** New messages for exact numeric datatypes (8114-8117).
*/
insert into sysmessages values
	(8114,16,0,'Error converting type %s to type %s.',NULL)
insert into sysmessages values
	(8115,16,0,'Arithmetic overflow error converting %s to type %s.',NULL)
insert into sysmessages values
	(8116,16,0,'Argument type %s is invalid for argument %d of %s function.',NULL)
insert into sysmessages values
	(8117,16,0,'Operand data type %s is invalid for %s operator.',NULL)
go

insert into sysmessages values
	(8118,16,0,'Column ''%.*s.%.*s'' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.',NULL)
insert into sysmessages values
	(8119,16,0,'Column ''%.*s.%.*s'' is invalid in the HAVING clause because it is not contained in an aggregate function and there is no GROUP BY clause.',NULL)
insert into sysmessages values
	(8120,16,0,'Column ''%.*s.%.*s'' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.',NULL)
insert into sysmessages values
	(8121,16,0,'Column ''%.*s.%.*s'' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.',NULL)
go

insert into sysmessages values
	(8122,16,0,'Only the first query in the UNION statement is allowed to have a select with assignment.',NULL)
go

insert into sysmessages values
	(8123,16,0,'A correlated expression is invalid because it is not in a GROUP BY clause.',NULL)
insert into sysmessages values
	(8124,16,0,'Multiple columns specified in an aggregated expression containing an outer reference. If an expression being aggregated contains an outer reference then that outer reference must be the only column reference in the expression.'
	,NULL)
insert into sysmessages values
	(8125,16,0,'An aggregated expression containing an outer reference must be contained in either the select list or a subquery of the HAVING clause of the query whose FROM clause contains the table containing the column being aggregated.',NULL)
insert into sysmessages values
	(8126,16,0,'Column name ''%.*s.%.*s'' is invalid in the ORDER BY clause because it is not contained in an aggregate function and there is no GROUP BY clause.',NULL)
insert into sysmessages values
	(8127,16,0,'Column name ''%.*s.%.*s'' is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid) values
	(8128,16,0,'Object identifier ''%.*s'' is longer than %d bytes.',NULL)

go

insert into sysmessages values
        (8129,16,0,'The new disk size must be greater than %d.  Or consider DBCC SHRINKDB.',NULL)
insert into sysmessages values
	(8130,16,1,'Device is not a database device. Only database devices can be expanded.',NULL)
insert into sysmessages values
	(8131,16,1,'Error occurred allocating resource during expansion of device TEMP_DB. Please consult the event log for details.',NULL)
insert into sysmessages values
	(8132,16,1,'The number of expansions of the device TEMP_DB has exceeded the system limit. In order to expand the device shutdown and restart the server.',NULL)
go
insert into sysmessages values
	(8133,16,2,'All the result expressions in a CASE specification must not be NULL.',NULL)
go
insert into sysmessages values
	(8134,16,0,'Divide by zero error encountered', NULL)
go

/*
** These are new messages for ADD CONSTRAINT
** Messages 8135 - 8153
*/
insert into sysmessages values
	(8135,16,0,'Table level constraint does not specify column list, table ''%.*s''.',NULL)
insert into sysmessages values
	(8136,16,0,'Duplicate columns specified in %s constraint key list, table ''%.*s''.',NULL)
insert into sysmessages values
	(8137,16,0,'Foreign key reference is missing target table name, table ''%.*s''.',NULL)
insert into sysmessages values
	(8138,16,0,'More than 16 columns specified in foreign key column list, table ''%.*s''.',NULL)
insert into sysmessages values
	(8139,16,0,'Number of referencing columns in foreign key differs from number of referenced columns, table ''%.*s''.',NULL)
insert into sysmessages values
	(8140,16,0,'More than one key specified in column level %s constraint, table ''%.*s''.',NULL)
insert into sysmessages values
	(8141,16,0,'Column %s constraint for column ''%.*s'' references another column, table ''%.*s''.',NULL)
insert into sysmessages values
	(8142,16,0,'Subqueries are not supported in %s constraints, table ''%.*s''.',NULL)
insert into sysmessages values
	(8147,16,0,'Attempt to create IDENTITY attribute on nullable column ''%.*s'', table ''%.*s''.',NULL)
insert into sysmessages values
	(8148,16,0,'More than one column %s constraint specified for column ''%.*s'', table ''%.*s''.',NULL)
insert into sysmessages values
	(8149,16,0,'Invalid column ''%.*s'' specified in %s definition, table ''%.*s''.',NULL)
insert into sysmessages values
	(8150,16,0,'Multiple NULL constraints specified for column ''%.*s'', table ''%.*s''.',NULL)
insert into sysmessages values
	(8151,16,0,'Both a primary key and unique constraint have been defined for column ''%.*s'', table ''%.*s''. Only one is allowed.',NULL)
insert into sysmessages values
	(8152,16,0,'Column ''%.*s'' of table ''%.*s'' cannot accept %d bytes (%d max).',NULL)
insert into sysmessages values
	(8153,0,0,'Warning, null value eliminated from aggregate.',NULL)
insert into sysmessages values
	(8154,15,2,'The table ''%.*s'' is ambiguous.',NULL)
insert into sysmessages values
	(8155,15,2,'No column name was specified for column %d of ''%.*s''.',NULL)
insert into sysmessages values
	(8156,15,2,'The column name ''%.*s'' was specified multiple times for ''%.*s''.',NULL)
insert into sysmessages values
	(8157,15,2,'All the queries in a query expression containing set operators must have the same number of expressions in their select lists.',NULL)
insert into sysmessages values
	(8158,15,2,'''%.*s'' has more columns than were specified in the column name list.',NULL)
insert into sysmessages values
	(8159,15,2,'''%.*s'' has fewer columns than were specified in the column name list.',NULL)
insert into sysmessages values
	(8160,15,2,'A GROUPING function can only be specified when either CUBE or ROLLUP is specified in the GROUP BY clause.',NULL)
insert into sysmessages values
	(8161,15,2,'A GROUPING function argument does not match any of the expressions in the GROUP BY clause.',NULL)
insert into sysmessages values
	(8162,16,0,'Formal parameter ''%.*s'' defined as OUTPUT but actual parameter not declared OUTPUT.', NULL)
insert into sysmessages values
	(8163,16,0,'Text/Image datatype cannot be selected as DISTINCT.',NULL)
insert into sysmessages values
	(8164,16,0,'An INSERT/EXEC statement cannot be nested.',NULL)
insert into sysmessages values
	(8165,16,2,'The maximum number of tables (%d) returning text or image data exceeded in a UNION ALL query.', NULL)
insert into sysmessages values
	(8166,16,2,'Illegal constraint name ''%.*s''.  Constraint names cannot begin with a pound sign (#).', NULL)
go

insert into sysmessages values
	(8143,16,2,'Parameter %.*s was supplied multiple times.',NULL)
insert into sysmessages values
	(8144,16,2,'Too many arguments supplied for procedure %.*s.',NULL)
insert into sysmessages values
	(8145,16,2,'%.*s is not a parameter for procedure %.*s.',NULL)
insert into sysmessages values
	(8146,16,2,'Procedure %.*s has no parameters and arguments were supplied.',NULL)

go


/* messages for dump table */

insert into sysmessages values
	(8301, 16, 2, 'Only user defined tables can be dumped with DUMP TABLE. Object ''%.*s'' is of type ''%s''.', NULL)

insert into sysmessages values
	(8302, 16, 2, 'Temporary tables cannot be dumped with DUMP TABLE.', NULL)

insert into sysmessages values
	(8303, 16, 2, 'Invalid database ''%.*s'' specified in DUMP TABLE.', NULL)

insert into sysmessages values
	(8304, 16, 2, 'Invalid table ''%.*s'' specified in DUMP TABLE.', NULL)

insert into sysmessages values
	(8305, 16, 2, 'Table ''%.*s'' has TEXT or IMAGE columns. DUMP TABLE cannot be performed.', NULL)
go


/* Load Table messages */

insert into sysmessages values
	(8401, 16, 2, 'Table ''%.*s'' contains data. Use the optional APPEND option for LOAD TABLE.', NULL)

insert into sysmessages values
	(8402, 16, 2, 'Only user defined tables can be loaded with LOAD TABLE. Object ''%.*s'' is of type ''%s''.', NULL)

insert into sysmessages values
	(8403, 16, 2, 'Table ''%.*s'' has indexes defined on it.', NULL)

insert into sysmessages values
	(8404, 16, 2, 'Table ''%.*s'' is published for replication.', NULL)

insert into sysmessages values
	(8405, 16, 2, 'Temporary tables cannot be dumped with LOAD TABLE.', NULL)

insert into sysmessages values
	(8406, 16, 2, 'Invalid database ''%.*s'' specified in LOAD TABLE.', NULL)

insert into sysmessages values
	(8407, 16, 2, 'Invalid target table ''%.*s'' specified in LOAD TABLE.', NULL)

insert into sysmessages values
	(8408, 16, 2, 'Table ''%.*s'' has TEXT or IMAGE columns. LOAD TABLE cannot be performed.', NULL)

insert into sysmessages values
	(8409, 16, 2, 'Invalid source table ''%.*s'' specified in LOAD TABLE.  Could not find table in SYSOBJECTS in dump.', NULL)

insert into sysmessages values
	(8410, 16, 2, 'Specified file ''%.*s'' is in an obsolete dump table format.', NULL)

insert into sysmessages values
	(8411, 16, 2, 'Unable to get column count for specified %s table ''%.*s''.', NULL)

insert into sysmessages values
	(8412, 16, 2, 'Schemas differ between source table ''%.*s'' and target table ''%.*s''.', NULL)

insert into sysmessages values
	(8413, 16, 2, 'Unable to retrieve column info for column %d in target table ''%.*s''.', NULL)

insert into sysmessages values
	(8414, 16, 2, 'Unable to load table ''%.*s'' as database does not have enough free space.', NULL)

insert into sysmessages values
	(8415, 16, 2, 'Table load has been aborted for table ''%.*s''.', NULL)

insert into sysmessages values
	(8416, 16, 2, 'LOAD TABLE is not allowed while the select into/bulk copy option is disabled: enable the option with sp_dboption.', NULL)
go



insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8501,16,1,'DTC on server ''%.*s'' is unavailable',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8502,20,1,'Unknown DTC token ''0x%x'' received',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8503,16,1,'Attempt to start distributed transaction while transaction active',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8504,20,1,'Invalid transaction import buffer',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8505,20,1,'No transaction context for ''%s'' request',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8506,20,1,'Invalid Transaction State Change Requested From: %s To: %s',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8507,20,1,'Transaction started for DTC transaction in ''%s'' state',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8508,20,1,'QueryInterface failed for ''%s'': %s',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8509,20,1,'Import of DTC transaction failed: %s',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8510,20,1,'Enlist of DTC transaction failed: %s',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8511,20,1,'Unknown isolation level ''%d'' requested from DTC',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8512,20,1,'DTC Commit Acknowledgement failed: %s',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8513,20,1,'DTC Abort acknowledgement failed: %s',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8514,20,1,'DTC Prepare acknowledgement failed: %s',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8515,20,1,'DTC Global state is invalid',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8516,20,1,'DTC upcall request posting failed',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8517,20,1,'Failed to get DTC PREPARE info: %s',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8518,20,1,'DTC Begin Transaction failed: %s',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8519,16,1,'Current DTC Transaction must be committed by remote client',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8520,20,1,'Commit of internal DTC transaction failed: %s',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8521,20,1,'Invalid awakening state. Slept in %s; awoke in %s',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8522,20,1,'Distributed transaction aborted by DTC',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8523,15,1,'PREPARE TRAN statement not allowed on DTC transaction',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(8524,16,1,'The current transaction couldn''t be exported to remote site. It has been rolled back.',NULL)


go
dump transaction master with no_log
go


insert into sysmessages values
	(13077,10,0,'a cursor declaration',NULL)
insert into sysmessages values
	(13078,10,0,'replication filter',NULL)
insert into sysmessages values
	(13079,10,0,'Variable assignment',NULL)

go

print ''
print 'Adding messages for replication stored procedures.'
go
/*
** Error messages for replication stored procedures.
*/
insert into sysmessages values
	(14001,16,0,'The destination table must not be qualified.',NULL)
insert into sysmessages values
	(14002,16,0,'The ''Sync'' subsystem with the Task id ''%ld'' was not found.',NULL)
insert into sysmessages values
	(14003,16,0,'You must supply a publication name.',NULL)
insert into sysmessages values
	(14004,16,0,'%s must be in the current database.',NULL)
insert into sysmessages values
	(14005,16,0,'Unable to drop publication. A subscription exists on it.',NULL)
insert into sysmessages values
	(14006,16,0,'Unable to drop the publication.',NULL)
insert into sysmessages values
	(14007,16,0,'You cannot change the destination database of a subscription unless it is inactive.',NULL)
insert into sysmessages values
	(14008,11,0,'There are no publications.',NULL)
insert into sysmessages values
	(14009,11,0,'There are no articles for publication ''%s''.',NULL)
insert into sysmessages values
	(14010,16,0,'The remote server is not defined as a subscription server.',NULL)
insert into sysmessages values
	(14011,16,0,'The publication you have selected does not exist or you do not have permission to access it.',NULL)
insert into sysmessages values
	(14012,16,0,'The @status value must be either ''active'' or ''inactive''.',NULL)
insert into sysmessages values
	(14013,16,0,'This database is not enabled for publication.',NULL)
insert into sysmessages values
	(14014,16,0,'The synchronization method (@sync_method) must be either ''[bcp] native'' or ''[bcp] character''.',NULL)
insert into sysmessages values
	(14015,16,0,'The replication frequency (@repl_freq) must be either ''continuous'' or ''snapshot''.',NULL)
insert into sysmessages values
	(14016,16,0,'The publication ''%s'' already exists.',NULL)
insert into sysmessages values
	(14017,16,0,'Invalid @restricted value.  Valid options are ''true'' or ''false''.',NULL)
insert into sysmessages values
	(14018,16,0,'The publication could not be created.',NULL)
insert into sysmessages values
	(14019,16,0,'The @operation must be either ''add'' or ''drop''.',NULL)
insert into sysmessages values
	(14020,16,0,'The column id for the specified column could not be obtained.  The column was not correctly added to the article.',NULL)
insert into sysmessages values
	(14021,16,0,'The column was not correctly added to the article.',NULL)
insert into sysmessages values
	(14022,16,0,'The property must be ''name'', ''description'', ''sync_object'', ''type'', ''status'', ''ins_cmd'', ''del_cmd'', ''upd_cmd'', ''filter'', ''dest_table'', ''creation_script'' or ''pre_creation_cmd''.',NULL)
insert into sysmessages values
	(14023,16,0,'The type must be ''logbased'', ''logbased manualfilter'', ''logbased manualview'', ''logbased manualboth''.',NULL)
insert into sysmessages values
	(14024,16,0,'The status must be ''active'' or ''inactive''.',NULL)
insert into sysmessages values
	(14025,10,0,'The article was successfully updated.',NULL)
insert into sysmessages values
	(14026,16,0,'The synchronization method must be ''[bcp] native'', ''[bcp] character'', or ''dump/load''.',NULL)
insert into sysmessages values
	(14027,11,0,'%s does not exist in the current database.',NULL)
insert into sysmessages values
	(14028,11,0,'User tables are the only objects that can be published.',NULL)
insert into sysmessages values
	(14029,16,0,'The vertical partition switch must be either ''true'' or ''false''.',NULL)
insert into sysmessages values
	(14030,16,0,'The article ''%s'' already exists in publication ''%s''.',NULL)
insert into sysmessages values
	(14031,16,0,'User tables and views are the only valid synchronization objects.',NULL)
insert into sysmessages values
	(14032,16,0,'Name ''all'' is reserved by replication stored procedures.',NULL)
insert into sysmessages values
	(14033,16,0,'Unable to change replication frequency because there are active subscriptions on the publication.',NULL)
insert into sysmessages values
	(14034,16,0,'The publication name @publication cannot be the keyword ''all''.',NULL)
insert into sysmessages values
	(14035,10,0,'Database ''%s'' is already enabled for publishing.',NULL)
insert into sysmessages values
	(14036,16,0,'Unable to enable database for publishing.',NULL)
insert into sysmessages values
	(14037,16,0,'Database ''%s'' is not enabled for publishing.',NULL)
insert into sysmessages values
	(14038,16,0,'Unable to disable database for publishing.',NULL)
insert into sysmessages values
	(14039,16,0, 'Unable to construct column clause for article view. Reduce the number of columns or create the view manually. ',NULL)
insert into sysmessages values
	(14040,16,0,'The server ''%s'' is already a subscriber.',NULL)
-- Placeholder for 14041
insert into sysmessages values
	(14042,16,0,'Unable to be create subscriber.',NULL)
insert into sysmessages values
	(14043,16,0,'%s cannot be NULL.',NULL)
insert into sysmessages values
	(14044,16,0,'Owner qualified %s names are not allowed.',NULL)
insert into sysmessages values
	(14045,16,0,'The task id must be unique.  The specified @taskid has already been used.',NULL)
insert into sysmessages values
	(14046,16,0,'Unable to drop article. A subscription exists on it.',NULL)
insert into sysmessages values
	(14047,16,0,'Unable to drop %s.',NULL)
insert into sysmessages values
	(14048,16,0,'The server ''%s'' is not a subscriber.',NULL)
insert into sysmessages values
	(14049,16,0,'Stored procedures for replication are the only objects that can be used as a filter.',NULL)
insert into sysmessages values
	(14050,11,0,'You do not have a subscription on this publication/article.',NULL)
insert into sysmessages values
	(14051,16,0,'The property must be ''sync_type'' or ''dest_db''.',NULL)
insert into sysmessages values
	(14052,16,0,'The sync_type must be ''manual'', ''automatic'' or ''none''.',NULL)
insert into sysmessages values
	(14053,16,0,'The subscription could not be updated at this time.',NULL)
insert into sysmessages values
	(14054,10,0,'The subscription was successfully updated.',NULL)
insert into sysmessages values
	(14055,10,0,'There is no subscription on article %s in publication %s for subscriber %s.',NULL)
insert into sysmessages values
	(14056,16,0,'The subscription could not be dropped at this time.',NULL)
insert into sysmessages values
	(14057,16,0,'The subscription could not be created.',NULL)
insert into sysmessages values
	(14058,16,0,'The subscription already exists.',NULL)
-- Placeholder for 14059
insert into sysmessages values
	(14060,16,0,'Unable to update distribution subscriber table.',NULL)
insert into sysmessages values
	(14061,16,0,'The pre_creation_cmd must be ''none'', ''drop'', ''delete'', ''truncate''.',NULL)
insert into sysmessages values
	(14062,10,0,'The subscriber was dropped.',NULL)
insert into sysmessages values
	(14063,11,0,'The remote server does not exist or has not been designated as a valid subscriber.',NULL)
insert into sysmessages values
	(14064,11,0,'There are no subscribers registered.',NULL)
insert into sysmessages values
	(14065,16,0,'The status must be ''active'', ''inactive'', or ''subscribed''.',NULL)
insert into sysmessages values
	(14066,16,0,'The previous status must be ''active'', ''inactive'', or ''subscribed''.',NULL)
insert into sysmessages values
	(14067,16,0,'The status value is the same as the previous status value.',NULL)
insert into sysmessages values
	(14068,16,0,'Unable to update sysobjects.  The subscription status could not be changed.',NULL)
insert into sysmessages values
	(14069,16,0,'Unable to update sysarticles.  The subscription status could not be changed.',NULL)
insert into sysmessages values
	(14070,16,0,'Unable to update the distribution database subscription table.  The subscription status could not be changed.',NULL)
insert into sysmessages values
	(14071,16,0,'This distribution database is unavailable.',NULL)
insert into sysmessages values
	(14072,16,0,'The publication you have selected is restricted.  Contact your system administrator or database owner to obtain permission to subscribe to this publication.  The subscription was not created.',NULL)
insert into sysmessages values
	(14073,16,0,'This procedure must be executed from the subscriber.',NULL)
insert into sysmessages values
	(14074,16,0,'The server ''%s'' is already listed as a publisher.',NULL)
insert into sysmessages values
	(14075,16,0,'The publisher could not be created at this time.',NULL)
insert into sysmessages values
	(14076,16,0,'Unable to grant replication login privilege to ''%s''.',NULL)
insert into sysmessages values
	(14077,10,0,'The publication was successfully updated.',NULL)
insert into sysmessages values
	(14078,16,0,'The property must be ''name'', ''description'', ''taskid'', ''sync_method'', ''status'', ''repl_freq'', or ''restricted''.',NULL)
insert into sysmessages values
	(14079,16,0,'Do not qualify the destination table name with a database.  Use the ''dest_db'' property of sp_changesubscription to specify a destination database.',NULL)
insert into sysmessages values
	(14080,11,0,'The remote server does not exist or has not been designated as a valid publisher.',NULL)
insert into sysmessages values
	(14081,16,0,'@replicated must be either ''true'' or ''false''.',NULL)
insert into sysmessages values
	(14082,10,0,'The object was successfully marked as a replicated object.',NULL)
insert into sysmessages values
	(14083,16,0,'The object was not successfully (un)marked as a replicated object.',NULL)
insert into sysmessages values
	(14085,16,0,'The subscriber information could not be obtained from the distributor.',NULL)
insert into sysmessages values
	(14086,16,0,'''%s'' is not a valid @subscriber_db.',NULL)
insert into sysmessages values
	(14087,16,0,'No completed transactions found.',NULL)
insert into sysmessages values
	(14088,16,0,'The table ''%s'' must have a primary key in order to be published using the tranaction-based method.',NULL)
insert into sysmessages values
	(14089,10,0,'''%ld'' replicated commands for subscriber ''%s'' were removed from the distribution database.',NULL)
insert into sysmessages values
	(14090,16,0,'A distribution server already exists.',NULL)
insert into sysmessages values
	(14091,16,0,'The @type parameter passed to sp_helpreplicationdb must be either ''pub'' or ''sub''.',NULL)
insert into sysmessages values
	(14092,16,0,'Unable to change article. A subscription exists on it.',NULL)
insert into sysmessages values
	(14093,16,0,'You must be System Administrator (SA) or the Database Owner (dbo) or a Replication Subscriber (repl_subscriber) to execute this stored procedure.',NULL)
insert into sysmessages values
	(14094,16,0,'Unable to subscribe to article ''%s'' because the ODBC subscriber ''%s'' does not support the ''truncate'' pre_creation_cmd.',NULL)
insert into sysmessages values
	(14095,16,0,'Unable to subscribe to publication ''%s'' because ODBC subscriber ''%s'' only supports the ''bcp character'' sync_method.',NULL)
insert into sysmessages values
	(14096,16,0,'The path and name of the table creation script must be specified if the pre-creation command is DROP.',NULL)
insert into sysmessages values
	(14097,16,0,'The type must be ''not owner qualified'', ''owner qualified'', ''no column names'', ''include column names''.',NULL)
insert into sysmessages values
	(14098,16,0,'Automatic syncronization can not be used for owner qualified articles.',NULL)
go

print ''
print 'Adding messages for SQL Executive replication subsystems.'
go
/*
** Adding messages for SQL Executive replication subsystems.
*/
insert into sysmessages values
	(14150,10,0,'Replication-%s: Task ''%s'' succeeded. %s',NULL)
insert into sysmessages values
	(14151,20,0,'Replication-%s: Task ''%s'' failed. %s',NULL)
insert into sysmessages values
	(14152,18,0x80,'Replication-%s: Task ''%s'' scheduled for retry after %d attempt(s). ''%s''',NULL)
insert into sysmessages values
	(14153,10,0,'Replication-%s: Task ''%s'' detected the potential for missing jobs on ''%s''. ',NULL)
go

print ''
print 'Adding messages for tasks.'
go
/*
** Error messages for tasks.
*/
insert into sysmessages values
	(14200,16,0,'Invalid frequency type.',NULL)
insert into sysmessages values
	(14201,16,0,'Invalid frequency subtype.',NULL)
insert into sysmessages values
	(14202,16,0,'Frequency interval invalid for this frequencytype; consult your documentation.',NULL)
insert into sysmessages values
	(14203,16,0,'Invalid frequency relative interval; consult your documentation.',NULL)
insert into sysmessages values
	(14204,16,0,'Active end date cannot be less than active start date.',NULL)
insert into sysmessages values
	(14205,16,0,'Active end time cannot be less than active start time.',NULL)
insert into sysmessages values
	(14206,16,0,'Next run date must be between active start date and active end date.',NULL)
insert into sysmessages values
	(14207,16,0,'Next run time must be between active start time and active end time.',NULL)
insert into sysmessages values
	(14208,16,0,'You must specify a task name.',NULL)
insert into sysmessages values
	(14209,16,0,'Server ''%s'' is not a registered remote server.',NULL)
insert into sysmessages values
	(14210,16,0,'A task named ''%s'' has already been created by ''%s''.  Please choose a different name.',NULL)
insert into sysmessages values
	(14211,16,0,'Database ''%s'' not found.',NULL)
insert into sysmessages values
	(14212,16,0,'Operator ''%s'' not found.',NULL)
insert into sysmessages values
	(14213,16,0,'Run priority must one of: -15 (idle), -2 (lowest), -1(low), 0 (normal), 1 (high), 2 (highest), 15 (time critical).',NULL)
insert into sysmessages values
	(14214,16,0,'Invalid log history completion level.',NULL)
insert into sysmessages values
	(14215,16,0,'Invalid email completion level.',NULL)
insert into sysmessages values
	(14216,16,0,'Invalid task id.',NULL)
insert into sysmessages values
	(14217,16,0,'You must be the sa or logged in as the owner of this task to update it.',NULL)
insert into sysmessages values
	(14218,16,0,'Invalid task name.',NULL)
insert into sysmessages values
	(14219,16,0,'You must be the sa or the owner of this task to drop it.',NULL)
insert into sysmessages values
	(14220,16,0,'Login ''%s'' not found.',NULL)
insert into sysmessages values
	(14221,16,0,'Administrator ''%s'' not found.',NULL)
insert into sysmessages values
	(14222,16,0,'Task ''%s'' not found.',NULL)
insert into sysmessages values
	(14223,16,0,'Task id ''%ld'' not found.',NULL)
insert into sysmessages values
	(14224,16,0,'You must be the sa, or specify a task for which you are the owner, to purge task histories.',NULL)
insert into sysmessages values
	(14225,16,0,'You must specify an Administrator name.',NULL)
insert into sysmessages values
	(14226,16,0,'Administrator ''%s'' already exists.',NULL)
insert into sysmessages values
	(14227,16,0,'You must specify an email address and/or a pager number for an administrator.',NULL)
insert into sysmessages values
	(14228,16,0,'Invalid pager start time.',NULL)
insert into sysmessages values
	(14229,16,0,'Invalid pager end time.',NULL)
insert into sysmessages values
	(14230,16,0,'Pager end time must be later than pager end time.',NULL)
insert into sysmessages values
	(14231,16,0,'Pager days must be one or more of Sunday (day 1) thru Saturday (day 7).',NULL)
insert into sysmessages values
	(14232,16,0,'You must be the sa to add, drop, or update administrators.',NULL)
insert into sysmessages values
	(14233,16,0,'Invalid admin id.',NULL)
insert into sysmessages values
	(14234,16,0,'Administrator ''%s'' is the Email Admin for one or more Tasks.  You must reassign those Tasks before dropping the Administrator.',NULL)
insert into sysmessages values
	(14235,16,0,'Administrator ''%s'' is the Email or Page Admin for one or more Alerts.  You must reassign those Alerts before dropping the Administrator.',NULL)
insert into sysmessages values
	(14236,16,0,'Invalid active end date.',NULL)
insert into sysmessages values
	(14237,16,0,'Invalid active end time of day.',NULL)
insert into sysmessages values
	(14238,16,0,'Invalid active start date.',NULL)
insert into sysmessages values
	(14239,16,0,'Invalid active start time of day.',NULL)
insert into sysmessages values
	(14240,16,0,'Invalid next run date.',NULL)
insert into sysmessages values
	(14241,16,0,'Invalid next run time.',NULL)
insert into sysmessages values
	(14244,16,0,'You must be sa to reassign tasks.',NULL)
insert into sysmessages values
	(14245,16,0,'You must specify either @name, @id or @loginname when dropping a task.',NULL)
insert into sysmessages values
	(14246,16,0,'You must specify the name or id of the task to be updated.',NULL)
insert into sysmessages values
	(14247,16,0,'The username (%s) you have specified is not your username (%s) in the %s database.  Only the SA or the DBO of %s may do this.',NULL)
insert into sysmessages values
	(14248,16,0,'This login is the owner of %ld Task(s).  You must drop or re-assign these Tasks before the login can be dropped.',NULL)
insert into sysmessages values
	(14249,16,0,'The @OpType parameter supplied is invalid - must be one of %s.',NULL)
insert into sysmessages values
	(14250,16,0,'A task with the @ID parameter supplied does not exist in systasks.',NULL)
insert into sysmessages values
	(14251,16,0,'The @TriggerType parameter supplied is invalid - must be one of %s.',NULL)
insert into sysmessages values
	(14252,16,0,'You cannot perform this action on a task you do not own.',NULL)
insert into sysmessages values
	(14253,16,0,'You cannot specify a remote server for a TSQL Task.',NULL)
insert into sysmessages values
	(14254,16,0,'Only the sa, repl_publisher and repl_subscriber can specify @loginname for another login.', NULL)
insert into sysmessages values
	(14255,16,0,'You must specify either @taskname or @oldloginname when re-assigning a task.', NULL)
go

print ''
print 'Adding messages for SQLOLE.'
go
/*
** Error messages for SQLOLE
*/
insert into sysmessages values
	(14300,16,0,'Circular dependencies exist. Dependency evaluation cannot continue.',NULL)
insert into sysmessages values
	(14301,16,0,'Logins other than the current user can only be seen by the SA.',NULL)

print ''
print 'Adding messages for alerts and operators.'
go
/*
** Error messages for alerts and operators proccedures (14500-14599)
*/
insert into sysmessages values
        (14500, 16, 0, 'You must supply either a zero (or NULL) for @message_id and a non-zero non-null value for @severity, or a zero (or NULL) for @severity and a non-zero non-null value for @message_id.', NULL)
insert into sysmessages values
        (14501, 16, 0, 'A task with the @task_name parameter you have supplied does not exist in systasks.', NULL)
insert into sysmessages values
        (14502, 16, 0, 'The @severity parameter you have supplied is not valid.', NULL)
insert into sysmessages values
        (14503, 16, 0, 'The @include_event_description_in parameter must be EMAIL, PAGER, BOTH or NONE.', NULL)
insert into sysmessages values
        (14504, 16, 0, 'The @delay_between_responses parameter must be greater than or equal to 0.', NULL)
insert into sysmessages values
        (14505, 16, 0, 'The @occurrence_count parameter must be greater than 0 or equal to 0.', NULL)
insert into sysmessages values
        (14506, 16, 0, 'An Alert for this @message_id - or @severity - with the same @event_description_keyword and @database_name values already exists (id = %s).', NULL)
insert into sysmessages values
        (14507, 16, 0, 'The @alert_name parameter you have supplied does not exist in sysalerts.', NULL)
insert into sysmessages values
        (14508, 16, 0, 'The @operator_name parameter you have supplied does not exist in sysoperators.', NULL)
insert into sysmessages values
        (14509, 16, 0, 'This Notification does not exist in sysnotifications.', NULL)
insert into sysmessages values
        (14510, 16, 0, 'The @object_type parameter must be either ALERTS or OPERATORS.', NULL)
insert into sysmessages values
        (14511, 16, 0, 'The @enum_type parameter must be either ALL, ACTUAL or TARGET.', NULL)
insert into sysmessages values
        (14512, 16, 0, 'The @notification_method parameter must be either EMAIL, PAGER or BOTH.', NULL)
insert into sysmessages values
        (14513, 16, 0, 'This Operator already exists.', NULL)
insert into sysmessages values
        (14514, 16, 0, 'The @pager_days parameter you have supplied is invalid.', NULL)
insert into sysmessages values
        (14515, 16, 0, 'This Notification already exists.', NULL)
insert into sysmessages values
        (14516, 16, 0, 'The @enabled parameter must be either 0 or 1.', NULL)
insert into sysmessages values
        (14517, 16, 0, 'The @notification_method parameter must be EMAIL, PAGER or BOTH.', NULL)
insert into sysmessages values
        (14518, 16, 0, 'The @message_id parameter you have supplied is not valid.', NULL)
insert into sysmessages values
        (14519, 16, 0, 'The @target_name parameter must be supplied when specifying an @enum_type of TARGET.', NULL)
insert into sysmessages values
        (14520, 16, 0, 'The @target_name parameter should not be supplied when specifying an @enum_type of ALL or ACTUAL.', NULL)
insert into sysmessages values
        (14521, 16, 0, 'The @target_name parameter does not exist in sys%s.', NULL)
insert into sysmessages values
        (14522, 16, 0, 'The @weekday_pager_start_time parameter is invalid (must be in HHMMSS format).', NULL)
insert into sysmessages values
        (14523, 16, 0, 'The @weekday_pager_end_time parameter is invalid (must be in HHMMSS format).', NULL)
insert into sysmessages values
        (14524, 16, 0, 'The @saturday_pager_start_time parameter is invalid (must be in HHMMSS format).', NULL)
insert into sysmessages values
        (14525, 16, 0, 'The @saturday_pager_end_time parameter is invalid (must be in HHMMSS format).', NULL)
insert into sysmessages values
        (14526, 16, 0, 'The @sunday_pager_start_time parameter is invalid (must be in HHMMSS format).', NULL)
insert into sysmessages values
        (14527, 16, 0, 'The @sunday_pager_end_time parameter is invalid (must be in HHMMSS format).', NULL)
insert into sysmessages values
        (14528, 16, 0, 'The @name or @new_name parameter you have supplied is not unique.', NULL)
insert into sysmessages values
        (14529, 16, 0, 'The @new_name parameter you have supplied is not unique.', NULL)
insert into sysmessages values
        (14530, 16, 0, '%s is the Fail-Safe Operator.  You must make another operator the Fail-Safe operator before %s can be dropped.', NULL)
insert into sysmessages values
        (14531, 16, 0, 'The @task_name parameter you have supplied is not an On-Demand task.  Only On-Demand tasks may be fired in response to an Alert.', NULL)
insert into sysmessages values
        (14532, 16, 0, 'The @raise_snmp_trap parameter must be either 0 or 1.', NULL)
insert into sysmessages values
        (14533, 16, 0, 'Alerts may not be set on Message ID %ld.', NULL)
go


---------------------------------------------------------------------------------

go
dump transaction master with no_log
go

------------ Reserved 15000-15999 for system sprocs.
print ' '
print 'Adding generic error messages for system stored procedures.'
print ' '
go

insert into sysmessages values
	(15000,16,0,'You must be System Administrator (SA) or the Database Owner (dbo) to execute this stored procedure.',NULL)
insert into sysmessages values
	(15001,16,0,'%s does not exist.',NULL)
insert into sysmessages values
	(15002,16,0,'The procedure ''%s'' cannot be executed from within a transaction.',NULL)
insert into sysmessages values
	(15003,16,0,'You must be System Administrator (SA) to execute this stored procedure.',NULL)
insert into sysmessages values
	(15004,16,0,'Name cannot be NULL.',NULL)
insert into sysmessages values
	(15005,16,0,'''%s'' is not a valid name since it begins with an invalid character.',NULL)
insert into sysmessages values	
	(15006,16,0,'''%s'' is not a valid name since it contains invalid characters.',NULL)
insert into sysmessages values
	(15007,16,0,'The login ''%s'' does not exist.',NULL)
insert into sysmessages values
	(15008,16,0,'User ''%s'' does not exist in the current database.',NULL)
insert into sysmessages values
	(15009,16,0,'The object ''%s'' does not exist in database ''%s''.',NULL)
insert into sysmessages values
	(15010,16,0,'The database ''%s'' does not exist.  Use sp_helpdb to show available databases.',NULL)
insert into sysmessages values
	(15011,16,0,'Database option ''%s'' does not exist.',NULL)
insert into sysmessages values
	(15012,16,0,'The device ''%s'' does not exist.  Use sp_helpdevice to show available devices.',NULL)
insert into sysmessages values
	(15013,16,0,'The device option ''%s'' does not exist or is not a settable option.',NULL)
insert into sysmessages values
	(15014,16,0,'The group ''%s'' does not exist in the current database.',NULL)
insert into sysmessages values
	(15015,16,0,'The server ''%s'' does not exist.  Use sp_helpserver to show available servers.',NULL)
insert into sysmessages values
	(15016,16,0,'The default ''%s'' does not exist.',NULL)
insert into sysmessages values
	(15017,16,0,'The rule ''%s'' does not exist.',NULL)
insert into sysmessages values
	(15018,16,0,'The segment ''%s'' does not exist.',NULL)
insert into sysmessages values
	(15019,16,0,'The extended stored procedure ''%s'' does not exist.',NULL)
insert into sysmessages values
	(15020,16,0,'The stored procedure ''%s'' does not exist in the current database.',NULL)
insert into sysmessages values
	(15021,16,0,'The report ''%s'' does not exist in the current database.',NULL)
insert into sysmessages values
	(15022,16,0,'The specified user name is already aliased.',NULL)
insert into sysmessages values
	(15023,16,0,'User ''%s'' already exists in the current database.',NULL)
insert into sysmessages values
	(15024,16,0,'The group ''%s'' already exists in the current database.',NULL)
insert into sysmessages values
	(15025,16,0,'The login ''%s'' already exists.',NULL)
insert into sysmessages values
	(15026,16,0,'Logical device ''%s'' already exists.',NULL)
insert into sysmessages values
	(15027,16,0,'The segment ''%s'' already exists.',NULL)
insert into sysmessages values
	(15028,16,0,'The server ''%s'' already exists.',NULL)
insert into sysmessages values
	(15029,16,0,'The type ''%s'' already exists in the current database.',NULL)
insert into sysmessages values
	(15030,16,0,'Physical device ''%s'' already exists.',NULL)
insert into sysmessages values
	(15031,16,0,'The object ''%s'' already exists in the current database.',NULL)
insert into sysmessages values
	(15032,16,0,'The database ''%s'' already exists.',NULL)
insert into sysmessages values
	(15033,16,0,'''%s'' is not a valid official language name.',NULL)
insert into sysmessages values
	(15034,16,0,'The alias ''%s'' already exists in Syslanguages.',NULL)
insert into sysmessages values
	(15035,16,0,'''%s'' is not a database device.',NULL)
insert into sysmessages values
	(15036,16,0,'The datatype ''%s'' does not exist.',NULL)
insert into sysmessages values
	(15037,16,0,'The physical datatype ''%s'' does not allow NULLs.',NULL)
insert into sysmessages values
	(15038,16,0,'User-defined datatypes based on the ''timestamp'' datatype are not allowed.',NULL)
insert into sysmessages values
	(15039,16,0,'The language ''%s'' already exists in Syslanguages.',NULL)
insert into sysmessages values
	(15040,16,0,'User defined error messages must have a number > 50000.',NULL)
insert into sysmessages values
	(15041,16,0,'User defined error messages must have a severity between 1 and 25.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid) values
	(15042,16,0,'Only the System Administrator (SA) may add messages with severity > 18 or which use the TRUE (for WITH_LOG) option.',NULL)
insert into sysmessages values
	(15043,16,0,'You must specify ''REPLACE'' to overwrite an existing message.',NULL)
insert into sysmessages values
	(15044,16,0,'''%s'' is an unknown device type.  Use ''disk'', ''tape'', ''diskette'' or ''pipe''.',NULL)
insert into sysmessages values
	(15045,16,0,'Logical name may not be NULL.',NULL)
insert into sysmessages values
	(15046,16,0,'Physical name may not be NULL.',NULL)
insert into sysmessages values
	(15047,16,0,'The only legal options for a tape device are ''skip'' and ''noskip''.',NULL)
insert into sysmessages values
	(15048,16,0,'''%s'' is not a valid database device type.  Please enter either ''system'' or ''data''.',NULL)
insert into sysmessages values
	(15049,16,0,'Database already exists, specify ''data'' instead of ''system'' as the database device type to install additional data devices for an existing database.',NULL)
go
insert into sysmessages values
	(15050,16,0,'No such database.  You must first create the database by defining its system device.',NULL)
insert into sysmessages values
	(15051,16,0,'The database size must be at least 1 Meg per device.',NULL)
insert into sysmessages values
	(15052,16,0,'A new location for the system device must be provided when installing the system database device.',NULL)
insert into sysmessages values
	(15053,16,0,'Objects exist which are not owned by the dbo.',NULL)
insert into sysmessages values
	(15054,16,0,'No more available device numbers.',NULL)
insert into sysmessages values
	(15055,16,0,'File ''%s'' cannot be opened.',NULL)
insert into sysmessages values
	(15056,16,0,'Error inserting into table ''%s''.  Database fragment not installed.',NULL)
insert into sysmessages values
	(15057,16,0,'List of %s name contains spaces, which are not allowed.',NULL)
insert into sysmessages values
	(15058,16,0,'List of %s has too few names.',NULL)
insert into sysmessages values
	(15059,16,0,'List of %s has too many names.',NULL)
insert into sysmessages values
	(15060,16,0,'List of %s names contains name(s) which have ''%s'' non-alphabetic characters.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid) values
	(15061,16,0,'Add Device request denied.  There is already a physical device named ''%s''.',NULL)
insert into sysmessages values
	(15062,16,0,'The ''guest'' user may not be mapped to a login name.',NULL)
insert into sysmessages values
	(15063,16,0,'Login already has an account under a different user name.',NULL)
insert into sysmessages values
	(15064,16,0,'Primary Key constraints do not have space allocated.',NULL)
insert into sysmessages values
	(15065,16,0,'All user ids have been assigned.',NULL)
insert into sysmessages values
	(15066,16,0,'There is already a default-name mapping of a remote login from remote server ''%s''.',NULL)
insert into sysmessages values
	(15067,16,0,'''%s'' isn''t a local user -- remote login denied.',NULL)
insert into sysmessages values
	(15068,16,0,'There is already a remote user named ''%s'' for remote server ''%s''.',NULL)
insert into sysmessages values
	(15069,16,0,'One or more users is using the database.  Cannot complete requested operation.',NULL)
insert into sysmessages values
	(15070,16,0,'The ''repl_subscriber'' user may only be mapped to the ''repl_subscriber'' login.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid) values
	(15071,16,0,'usage: sp_addmessage <msgnum>,<severity>,<msgtext> [,<language> [,FALSE | TRUE [,REPLACE]]]',NULL)
insert into sysmessages values
	(15072,16,0,'Usage: sp_addremotelogin remoteserver [, loginame [,remotename]]',NULL)
insert into sysmessages values
	(15073,16,0,'The device ''%s'' is not used by database ''%s''.',NULL)
insert into sysmessages values
	(15074,16,0,'''%s'' is reserved exclusively as a log device.',NULL)
insert into sysmessages values
	(15075,16,0,'The maximum number of segments for the current database are already defined.',NULL)
insert into sysmessages values
	(15076,16,0,'Default and table or user datatype must be in the ''current'' database.',NULL)
insert into sysmessages values
	(15077,16,0,'Rule and table or usertype must be in the ''current'' database.',NULL)
insert into sysmessages values
	(15078,16,0,'Table or view name must be in the ''current'' database.',NULL)
insert into sysmessages values
	(15079,10,0,'Queries processed:  %d.',NULL)
insert into sysmessages values
	(15080,17,0,'Failure using SQLMapi, check SQL Server error log.',NULL)
insert into sysmessages values
	(15081,16,0,'The dependent table or view does not exist in the current database.',NULL)
insert into sysmessages values
	(15082,11,1,'NULL is not an acceptable parm value for this proc.  Please use a percent sign instead.',NULL)
insert into sysmessages values
	(15083,16,0,'Report must be in the ''current'' database.',NULL)
insert into sysmessages values
	(15084,16,0,'Column or user datatype must be in the ''current'' database.',NULL)
insert into sysmessages values
	(15085,16,0,'Usage: sp_addtype name, ''datatype'' [,null | nonull]',NULL)
insert into sysmessages values
	(15086,16,0,'Illegal precision specified -- must be between 1 and 38.',NULL)
insert into sysmessages values
	(15087,16,0,'Illegal scale specified -- must be less than precision and positive.',NULL)
insert into sysmessages values
	(15088,16,0,'Physical type is fixed length. You cannot specify the length.',NULL)
insert into sysmessages values
	(15089,11,0,'No database can have its ''%s'' option changed while another user is in the database.',NULL)
insert into sysmessages values
	(15090,16,0,'There is already a local server.',NULL)
insert into sysmessages values
	(15091,16,0,'You must specify a length with this physical type.',NULL)
insert into sysmessages values
	(15092,16,0,'Illegal length specified -- must be between 1 and 255.',NULL)
insert into sysmessages values
	(15093,16,0,'''%s'' is not a valid date order.',NULL)
insert into sysmessages values
	(15094,16,0,'''%s'' is not a valid first day.',NULL)
insert into sysmessages values
	(15095,16,0,'Insert into ''syslanguages'' failed.  Language not added.',NULL)
insert into sysmessages values
	(15096,16,0,'Only the System Administrator (SA) or ''%s'' can change ''%s''s default language.',NULL)
insert into sysmessages values
	(15097,16,0,'Can''t drop ''%s'' because there are associated entries in master.dbo.sysmessages.  Run sp_droplanguage with dropmessages flag.',NULL)
insert into sysmessages values
	(15098,16,0,'The only legal value for @dropmessages is ''dropmessages''.',NULL)
insert into sysmessages values
	(15099,16,0,'Update of ''syslanguages'' failed.  Language alias not changed.',NULL)
go
insert into sysmessages values
	(15100,16,0,'Usage: sp_bindefault defaultname, objectname [, ''futureonly'']',NULL)
insert into sysmessages values
	(15101,16,0,'You cannot bind a default to a column of datatype ''timestamp''.',NULL)
insert into sysmessages values
	(15102,16,0,'You cannot bind a default to an identity column.',NULL)
insert into sysmessages values
	(15103,16,0,'You cannot bind a default to a column that was created with or altered to have a default value.',NULL)
insert into sysmessages values
	(15104,16,0,'You do not own a table named ''%s'' that has a column named ''%s''.',NULL)
insert into sysmessages values
	(15105,16,0,'You do not own a datatype with that name.',NULL)
insert into sysmessages values
	(15106,16,0,'Usage: bindrule rulename, objectname [, ''futureonly'']',NULL)
insert into sysmessages values
	(15107,16,0,'You cannot bind a rule to a column of datatype ''text'', ''image'', or ''timestamp''.',NULL)
insert into sysmessages values
	(15108,16,0,'Only the System Administrator (SA) can change the owner of a database.',NULL)
insert into sysmessages values
	(15109,16,0,'The owner of the ''master'' database may not be changed.',NULL)
insert into sysmessages values
	(15110,16,0,'The proposed new db owner already is a user in the database.',NULL)
insert into sysmessages values
	(15111,16,0,'The proposed new db owner already is aliased in the database.',NULL)
insert into sysmessages values
	(15112,16,0,'First table in the common key does not exist.',NULL)
insert into sysmessages values
	(15113,16,0,'Second table in the common key does not exist.',NULL)
insert into sysmessages values
	(15114,16,0,'Only the table owner may define its common keys.',NULL)
insert into sysmessages values
	(15115,16,0,'The tables have no such first column or the columns are of different types.',NULL)
insert into sysmessages values
	(15116,16,0,'The tables have no such second column or the columns are of different types.',NULL)
insert into sysmessages values
	(15117,16,0,'The tables have no such third column or the columns are of different types.',NULL)
insert into sysmessages values
	(15118,16,0,'The tables have no such fourth column or the columns are of different types.',NULL)
insert into sysmessages values
	(15119,16,0,'The tables have no such fifth column or the columns are of different types.',NULL)
insert into sysmessages values
	(15120,16,0,'The tables have no such sixth column or the columns are of different types.',NULL)
insert into sysmessages values
	(15121,16,0,'The tables have no such seventh column or the columns are of different types.',NULL)
insert into sysmessages values
	(15122,16,0,'The tables have no such eighth column or the columns are of different types.',NULL)
insert into sysmessages values
	(15123,16,0,'The configuration option ''%s'' does not exist, or maybe it is an advanced option.',NULL)
insert into sysmessages values
	(15124,16,0,'The configuration option ''%s'' is not unique.',NULL)
insert into sysmessages values
	(15125,16,0,'Only the System Administrator (SA) may change configuration parameters.',NULL)
insert into sysmessages values
	(15126,16,0,'You cannot set the number of devices to be less than the number of devices already defined in sysdevices.',NULL)
insert into sysmessages values
	(15127,16,0,'You cannot set the default language to a language ID that is not defined in Syslanguages.',NULL)
insert into sysmessages values
	(15128,16,0,'You cannot set the kernel language to a language ID that is not defined in Syslanguages.',NULL)
insert into sysmessages values
	(15129,16,0,'''%d'' is not a valid value for configuration option ''%s''.',NULL)
insert into sysmessages values
	(15130,16,0,'usage: sp_dbinstall <dbname>,<logical devname>,<physical devname>,<size>,{''system'' | ''data''},[''new location'']',NULL)
insert into sysmessages values
	(15131,16,0,'usage: sp_dbremove <dbname> [,dropdev]',NULL)
insert into sysmessages values
	(15132,16,0,'You cannot change someone else''s default database.',NULL)
insert into sysmessages values
	(15133,16,0,'Cannot change settings for ''master'' device.',NULL)
insert into sysmessages values
	(15134,16,0,'No alias for specified user exists.',NULL)
insert into sysmessages values
	(15135,16,0,'Device option ''%s'' is not unique.',NULL)
insert into sysmessages values
	(15136,16,0,'usage: sp_devoption [devname, optname, {true | false}[,''override'']]',NULL)
insert into sysmessages values
	(15137,16,0,'Only the System Administrator (SA) may set device options.',NULL)
insert into sysmessages values
	(15138,16,0,'Cannot set device to ''read only'' because it is used by non ''read only'' database(s).  Use sp_dboption to set database options.',NULL)
insert into sysmessages values
	(15139,16,0,'The device is a RAM disk and cannot be used as a default device.',NULL)
insert into sysmessages values
	(15140,16,0,'Usage: sp_diskdefault logicalname {defaulton | defaultoff}.',NULL)
insert into sysmessages values
	(15141,16,0,'Cannot drop device since it is being used by one or more databases.',NULL)
insert into sysmessages values
	(15142,16,0,'Cannot drop the group ''public''.',NULL)
insert into sysmessages values
	(15143,16,0,'''%s'' is not a valid option for @updateusage.  Please enter either ''true'' or ''false''.',NULL)
insert into sysmessages values
	(15144,16,0,'Group has members.  It must be empty before it can be dropped.',NULL)
insert into sysmessages values
	(15145,16,0,'Usage: sp_dropkey {primary | foreign | common}, tabname [,deptabname].  Type must be ''primary'', ''foreign'', or ''common''.',NULL)
insert into sysmessages values
	(15146,16,0,'You must be the owner of the table or view to drop its key.',NULL)
insert into sysmessages values
	(15147,16,0,'No primary key for the table or view exists.',NULL)
insert into sysmessages values
	(15148,16,0,'You need to supply the dependent table or view as the third parameter.',NULL)
insert into sysmessages values
	(15149,16,0,'No foreign key for the table or view exists.',NULL)
go
insert into sysmessages values
	(15150,16,0,'No common keys exist between the two tables or views supplied.',NULL)
insert into sysmessages values
	(15151,16,0,'Foreign key table does not exist.',NULL)
insert into sysmessages values
	(15152,16,0,'Primary key table does not exist.',NULL)
insert into sysmessages values
	(15153,16,0,'Only the owner of the table may define a foreign key.',NULL)
insert into sysmessages values
	(15154,16,0,'The table has no such first column.',NULL)
insert into sysmessages values
	(15155,16,0,'The table has no such second column.',NULL)
insert into sysmessages values
	(15156,16,0,'The table has no such third column.',NULL)
insert into sysmessages values
	(15157,16,0,'The table has no such fourth column.',NULL)
insert into sysmessages values
	(15158,16,0,'The table has no such fifth column.',NULL)
insert into sysmessages values
	(15159,16,0,'The table has no such sixth column.',NULL)
insert into sysmessages values
	(15160,16,0,'The table has no such seventh column.',NULL)
insert into sysmessages values
	(15161,16,0,'The table has no such eighth column.',NULL)
insert into sysmessages values
	(15162,16,0,'Primary key does not exist with the same number of columns as the foreign key.',NULL)
insert into sysmessages values
	(15163,16,0,'Primary key does not exist.',NULL)
insert into sysmessages values
	(15164,16,0,'Datatypes of the first column in the keys are different.',NULL)
insert into sysmessages values
	(15165,16,0,'Datatypes of the second column in the keys are different.',NULL)
insert into sysmessages values
	(15166,16,0,'Datatypes of the third column in the keys are different.',NULL)
insert into sysmessages values
	(15167,16,0,'Datatypes of the fourth column in the keys are different.',NULL)
insert into sysmessages values
	(15168,16,0,'Datatypes of the fifth column in the keys are different.',NULL)
insert into sysmessages values
	(15169,16,0,'Datatypes of the sixth column in the keys are different.',NULL)
insert into sysmessages values
	(15170,16,0,'Datatypes of the seventh column in the keys are different.',NULL)
insert into sysmessages values
	(15171,16,0,'Datatypes of the eighth column in the keys are different.',NULL)
insert into sysmessages values
	(15172,16,0,'Only the owner of the table may define a primary key.',NULL)
insert into sysmessages values
	(15173,16,0,'Primary key already exists on table -- drop key first.',NULL)
insert into sysmessages values
	(15174,16,0,'Login ''%s'' owns one or more database(s).  Change the owner of the following database(s) before dropping login:',NULL)
insert into sysmessages values
	(15175,16,0,'Login ''%s'' is aliased or mapped to a user in one or more database(s).  Drop user or alias before dropping login.',NULL)
insert into sysmessages values
	(15176,16,0,'The only valid @parameter value is WITH_LOG.',NULL)
insert into sysmessages values
	(15177,16,0,'usage: sp_dropmessage <msg number> [,<language> | ''ALL'']',NULL)
insert into sysmessages values
	(15178,16,0,'Cannot drop a message with a number < 50000.',NULL)
insert into sysmessages values
	(15179,16,0,'Message number %u does not exist.',NULL)
insert into sysmessages values
	(15180,16,0,'Type is being used. You cannot drop it.',NULL)
insert into sysmessages values
	(15181,16,0,'You cannot drop the ''database owner''.',NULL)
insert into sysmessages values
	(15182,16,0,'You cannot drop the ''guest'' user from master or tempdb.',NULL)
insert into sysmessages values
	(15183,16,0,'The user owns objects in the database and cannot be dropped.',NULL)
insert into sysmessages values
	(15184,16,0,'The user owns datatypes in the database and cannot be dropped.',NULL)
insert into sysmessages values
	(15185,16,0,'There is no remote user ''%s'' mapped to local user ''%s'' from the remote server ''%s''.',NULL)
insert into sysmessages values
	(15186,16,0,'Cannot drop segment ''%s'' completely.',NULL)
insert into sysmessages values
	(15187,16,0,'The segment ''%s'' is being used.',NULL)
insert into sysmessages values
	(15188,16,0,'Segment ''%s'' does not reference device ''%s''.',NULL)
insert into sysmessages values
	(15189,16,0,'There is only one unique device mapping for the segment ''%s'' -- use sp_dropsegment with no device argument.',NULL)
insert into sysmessages values
	(15190,16,0,'There are still remote logins for the server ''%s''.',NULL)
insert into sysmessages values
	(15191,16,0,'Usage: sp_dropserver server [, droplogins]',NULL)
insert into sysmessages values
	(15192,16,0,'Can''t make the only segment on original device log-only.',NULL)
insert into sysmessages values
	(15193,16,0,'This procedure can be used on system tables only.',NULL)
insert into sysmessages values
	(15194,16,0,'Cannot re-create index on this table.',NULL)
insert into sysmessages values
	(15195,16,0,'The first table does not exist.',NULL)
insert into sysmessages values
	(15196,16,0,'The second table does not exist.',NULL)
insert into sysmessages values
	(15197,16,0,'There is no text for object ''%s''',NULL)
insert into sysmessages values
	(15198,16,0,'The name supplied (%s) is not a user, group, or aliased.',NULL)
insert into sysmessages values
	(15199,16,0,'Only the System Administrator (SA) or the Database Owner (dbo) may move the syslogs table.',NULL)
go
insert into sysmessages values
	(15200,16,0,'There are no remote servers defined.',NULL)
insert into sysmessages values
	(15201,16,0,'There are no remote logins for the remote server ''%s''.',NULL)
insert into sysmessages values
	(15202,16,0,'There are no remote logins defined.',NULL)
insert into sysmessages values
	(15203,16,0,'There are no remote logins for ''%s''.',NULL)
insert into sysmessages values
	(15204,16,0,'There are no remote logins for ''%s'' on remote server ''%s''.',NULL)
insert into sysmessages values
	(15205,16,0,'There are no servers defined.',NULL)
insert into sysmessages values
	(15206,16,0,'Invalid Remote Server Option: ''%s''',NULL)
insert into sysmessages values
	(15207,16,0,'usage: sp_makestartup <procname>',NULL)
insert into sysmessages values
	(15208,16,0,'The specified procedure must be owned by the SA.',NULL)
insert into sysmessages values
	(15209,16,0,'Procedure expects parameters.  Cannot be used as a startup stored procedure.',NULL)
insert into sysmessages values
	(15210,16,0,'Only System Administrator (SA) can use loginame option -- password not changed.',NULL)
insert into sysmessages values
	(15211,16,0,'Old (current) password incorrect for user -- password not changed.',NULL)
insert into sysmessages values
	(15212,16,0,'Use sp_logdevice to move syslogs table.',NULL)
insert into sysmessages values
	(15213,16,0,'You cannot move system tables.',NULL)
insert into sysmessages values
	(15214,16,0,'You do not own a table named ''%s''.',NULL)
insert into sysmessages values
	(15215,16,0,'There is no index named ''%s'' for table ''%s''.',NULL)
insert into sysmessages values
	(15216,16,0,'''%s'' is not a valid option for @delfile.',NULL)
insert into sysmessages values
	(15217,16,0,'''%s'' is a system table.  sp_recompile cannot be used on system tables.',NULL)
insert into sysmessages values
	(15218,16,0,'Object ''%s'' is not a table.',NULL)
insert into sysmessages values
	(15219,16,0,'You do not own table ''%s''.  Only the System Administrator (SA) or the table''s owner may perform this action.',NULL)
insert into sysmessages values
	(15220,16,0,'Usage: sp_remoteoption [remoteserver, loginame, remotename, optname, {true | false}]',NULL)
insert into sysmessages values
	(15221,16,0,'Remote login option does not exist or cannot be set by user.  Run sp_remoteoption with no parameters to see options.',NULL)
insert into sysmessages values
	(15222,16,0,'Remote login option ''%s'' is not unique.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15223,11,1,'Error, the input parameter ''%s'' is not allowed to be null.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15224,11,1,'Error, the value for parameter NewName contains invalid characters or violates a basic restriction (%s).',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15225,11,1,'No item by the name of ''%s'' could be found in the current database ''%s'', given that ItemType was input as ''%s''.',NULL)
insert into sysmessages values
	(15226,16,0,'Only the System Administrator (SA) can change the name of a database.',NULL)
insert into sysmessages values
	(15227,16,0,'The database ''%s'' cannot be renamed.',NULL)
insert into sysmessages values
	(15228,16,0,'The System Administrator (SA) must set database ''%s'' to single-user mode with sp_dboption before it can be renamed.',NULL)
insert into sysmessages values
	(15229,16,0,'usage: sp_serveroption [server, optname, {true | false}]',NULL)
insert into sysmessages values
	(15230,16,0,'Server option ''%s'' does not exist or cannot be set by user.  Run sp_serveroption with no parameters to see options.',NULL)
insert into sysmessages values
	(15231,16,0,'Server option ''%s'' is not unique.',NULL)
insert into sysmessages values
	(15232,16,0,'Only the System Administrator (SA) may set server options.',NULL)
insert into sysmessages values
	(15233,16,0,'There is already a server network name ''%s''.',NULL)
insert into sysmessages values
	(15234,16,0,'Object is stored in ''sysprocedures'' and has no space allocated directly.',NULL)
insert into sysmessages values
	(15235,16,0,'Views do not have space allocated.',NULL)
insert into sysmessages values
	(15236,16,0,'Column ''%s'' has no default.',NULL)
insert into sysmessages values
	(15237,16,0,'User datatype ''%s'' has no default.',NULL)
insert into sysmessages values
	(15238,16,0,'Column ''%s'' has no rule.',NULL)
insert into sysmessages values
	(15239,16,0,'User datatype ''%s'' has no rule.',NULL)
insert into sysmessages values
	(15240,16,0,'usage: sp_unmakestartup <procname>',NULL)
insert into sysmessages values
	(15241,16,0,'usage: sp_dboption [dbname [,optname [,''true'' | ''false'']]]',NULL)
insert into sysmessages values
	(15242,16,0,'Database option ''%s'' is not unique.',NULL)
insert into sysmessages values
	(15243,16,0,'The option ''%s'' cannot be changed for the ''master'' database.',NULL)
insert into sysmessages values
	(15244,16,0,'Only the System Administrator (SA) or the owner of the database may set db options.',NULL)
insert into sysmessages values
	(15245,16,0,'''DBCC DBCONTROL'' error.  Database not placed offline.',NULL)
insert into sysmessages values
	(15246,16,0,'Cannot bring database online due to problem opening device ''%s''.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15247,11,1,'Error, you must specify an explicit ItemType whenever you pass in a qualified OldName.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15248,11,1,'Error, the parameter OldName is either ambiguous or the claimed ItemType (%s) was wrong.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15249,11,1,'Error, explicit ItemType ''%s'' is unrecognized (%d).',NULL)
go
insert into sysmessages values
	(15250,16,0,'Database name component of object qualifier must be name of current database.',NULL)
insert into sysmessages values
	(15251,16,0,'Illegal ''%s'' specified -- must be %s.',NULL)
insert into sysmessages values
	(15252,16,0,'PK table name or FK table name must be given.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15253,11,1,'Error, the parameter OldName is incorrect because it contains too many qualification dots to parse apart.  (OldName=%s / LowestNode=%s)',NULL)
insert into sysmessages values
	(15254,16,0,'Non dbo/guest users exist in database.  Please drop them before removing database.',NULL)
insert into sysmessages values
	(15255,11,1,'''%s'' is not a valid value for @autofix.  The only valid option is ''auto''.',NULL)
insert into sysmessages values
	(15256,16,0,'usage: sp_certify_removable <dbname> [,''auto'']',NULL)
insert into sysmessages values
	(15257,16,0,'You cannot be USEing the database that you are attempting to certify.',NULL)
insert into sysmessages values
	(15258,16,0,'The database must be owned by the System Administrator before it can be removed.',NULL)
insert into sysmessages values
	(15259,16,0,'The database must occupy at least three database devices (one each for the ''system'' and ''log'' segments and one or more for the ''data'' segment(s)) before it can be removed.',NULL)
insert into sysmessages values
	(15260,16,0,'The database has cannot be removed since it has noncontiguous fragments on one or more devices.',NULL)
insert into sysmessages values
	(15261,16,0,'usage: sp_create_removable <dbname>,<syslogical>,<sysphysical>,<syssize>,<loglogical>,<logphysical>,<logsize>,<datalogical1>,<dataphysical1>,<datasize1> [,<datalogical2>,<dataphysical2>,<datasize2>...<datalogical16>,<dataphysical
16>,<datasize16>]',NULL)
insert into sysmessages values
	(15262,16,0,'Invalid device size entered.  Database devices must be at least 1 Meg. in size.',NULL)
insert into sysmessages values
	(15263,16,0,'Could not create the ''%s'' device.  See the errorlog for details.',NULL)
insert into sysmessages values
	(15264,16,0,'Could not create the ''%s'' portion of the database.',NULL)
insert into sysmessages values
	(15265,16,0,'Could not update sysusages.segmap.',NULL)
insert into sysmessages values
	(15266,16,0,'Cannot make ''%s'' database removable.',NULL)
insert into sysmessages values
	(15267,16,0,'You must supply a physical device for logical data device ''%s''.',NULL)
insert into sysmessages values
	(15268,16,0,'You must supply a size for logical data device ''%s''.',NULL)
insert into sysmessages values
	(15269,16,0,'Logical data device ''%s'' not created.',NULL)
insert into sysmessages values
	(15270,16,0,'You may not specify a length for user types based on the ''sysname'' type.',NULL)
insert into sysmessages values
	(15271,16,0,'Invalid @with_log value.  Valid options are ''true'' or ''false''.',NULL)
insert into sysmessages values
	(15272,16,0,'Procedure ''%s'' is not a valid startup procedure since startup procedures must be in the ''master'' database.',NULL)
insert into sysmessages values
	(15273,16,0,'Cannot make ''%s'' a startup procedure since startup procedures must be in the ''master'' database and the current database is ''%s''.',NULL)
insert into sysmessages values
	(15274,16,0,'Procedure ''%s'' is not a valid startup procedure since startup procedures must be in the ''master'' database and the current database is ''%s''.',NULL)
insert into sysmessages values
	(15275,16,0,'Foreign Key constraints do not have space allocated.',NULL)
insert into sysmessages values
	(15276,16,0,'User datatypes based on the physical type ''bit'' may not be nullable.',NULL)
insert into sysmessages values
	(15277,16,0,'The only valid @parameter_value values are TRUE or FALSE.',NULL)
insert into sysmessages values
	(15278,16,0,'Login: ''%s'' is already mapped to user: ''%s'' in database: ''%s''.',NULL)
insert into sysmessages values
	(15279,16,0,'You must add the us_english version of this message before you can add the ''%s'' version.',NULL)
insert into sysmessages values
	(15280,16,0,'All localized versions of this message must be dropped before the us_english version can be dropped.',NULL)
insert into sysmessages values
	(15281,16,0,'''%s'' is not a valid value for @override.  Please omit or use ''override''.',NULL)
insert into sysmessages values
	(15282,16,0,'You may only specify ''override'' when setting the ''read only'' option.',NULL)
insert into sysmessages values
	(15283,16,0,'The name ''%s'' contains too many characters.',NULL)
insert into sysmessages values
	(15284,16,0,'The user has granted/revoked privileges to the following in the database and cannot be dropped.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15285,16,0,'The special word ''%s'' cannot be used for a logical device name.',NULL)
insert into sysmessages  --sp_change_users_login
	(error ,severity ,dlevel ,description ,langid)
	values
	(15286,16,0,'Aborting this procedure.  The Action ''%s'' is unrecognized.  Try REPORT, UPDATE_ONE, or AUTO_FIX.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15287,16,0,'Aborting this procedure.  ''%s'' is a forbidden value for the login name parm in this procedure.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15288,16,0,'Aborting this procedure.  Only %s has authority to run the action ''%s''.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15289,16,0,'Aborting this procedure.  You must not have an open transaction when this is run.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15290,16,0,'Aborting this procedure.  The Action ''%s'' is incompatible with the other parm values (''%s'' , ''%s'').',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15291,16,0,'Aborting this procedure.  The %s name ''%s'' is absent or invalid.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15292,0,1,'The row for User ''%s'' will be fixed by updating its login link to a login already in existence.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15293,0,1,'Barring a conflict, the row for User ''%s'' will be fixed by updating its link to a new login (consider changing the new password from Null to something else).',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15294,0,1,'Number of orphaned Users fixed by adding new logins then updating users was %d.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15295,0,1,'Number of orphaned Users fixed by updating users was %d.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15296,11,1,'The requested SUID value %d is already taken by ''%s''.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15297,16,1,'Attempt to add login ''%s'' was NOT successful.  Maximum number of logins already reached.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15298,0,1,'New login created.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15299,11,1,'An identifying name is too long (%s).',NULL) --default,rule
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15300,11,1,'No recognized letter is contained in the parm value for General Permission Type (%s).  Valid letters are in this set:  %s .',NULL)
go
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15301,11,1,'Login not added.  The requested SUID value (%d) is not greater than 1.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15302,11,1,'Database_Name should not be used to qualify owner.object for the parm into this proc.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
	values
	(15303,11,1,'"user options" config value (%d) was rejected because it would try to set incompatible options.',NULL)
insert into sysmessages 
	(error ,severity ,dlevel ,description ,langid)
	values
	(15304,16,0,'The severity of the ''%s'' version of this message must be the same as the severity (%ld) of the us_english version.',NULL)

insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15309,0,1,'The following devices are ready for removal.  Please carefully note this info for later use with sp_dbinstall:',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15310,0,1,'%d noncomment records were written to Log\CertifyR*.TXT file.',NULL)

insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15313,0,1,'   Notice, ''%s'' is a system provided database.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15314,17,127,'Warning: Conflicting fragment information for database %d near vstart %d!',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15315,0,1,'The number of sysusages fragments was reduced by %d.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15316,0,1,'Caution, the fragment size expressed in Mb is rounded up from the size expressed in 2Kb pages. A create/alter must have requested more space than was available. Thus the create/alters below might not produce the intended lpage/segmap c
ombinations.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15317,0,1,'No action needed or taken, because all fragments for database ''%s'' on device ''%s'' are already dedicated for log usage only.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15318,0,1,'All fragments for database ''%s'' on device ''%s'' are now dedicated for log usage only.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15319,17,1,'Error, DBCC DBRepair Remap failed for database ''%s'' (for device ''%s'')!',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15320,11,1,'Action denied.  Fragments to be dedicated to log usage for a database cannot be on the device containing logical page 0 for that database. (%s, %s)',NULL)

insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15329,11,1,'There are no database names LIKE the attempted pattern.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15330,11,1,'There are no matching rows on which to report.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15331,11,1,'The user ''%s'' cannot be AUTO_FIXed because another user has suid=%d.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15332,11,1,'Error, for an ItemType of ''%s'' the value for parameter OldName must include at least one qualifier (as in TheTable.TheColumn).',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15333,11,1,'Error, the qualified OldName references a database (%s) other than the current database.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15334,11,1,'Error, only SA or DBO can rename items they do not own.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15335,11,1,'Error, the NewName ''%s'' is already in use as a  %s  name and would cause an illegal duplicate.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15336,11,1,'Error, renaming an Object of type=''%s'' would result in a discrepancy in syscomments.text.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15337,0,1,'Caution, sysdepends shows that other objects (views, procs etc) are referencing this object by its old name.  Thus these objects will become invalid, and should be dropped/recreated promptly.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15338,0,1,'The  %s  was renamed to ''%s''.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15339,0,1,'Creating ''%s''.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15340,0,1,'Alias user added.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15341,0,1,'New group added.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15342,0,1,'Replacing message.',NULL)
insert into sysmessages
	(error ,severity ,dlevel ,description ,langid)
        values
	(15343,0,1,'New message added.',NULL)
go

----sp_fallback_ (approx 15344-15385)  1996/02/28 13:31

insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15344,11,1,'Unable to convert null parameter for primary server name into exactly one name (found %d possibilities).  Aborting this procedure.',NULL)

insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15345,11,1,'This fallback server ''%s'' has no databases enrolled for the primary server ''%s'' which match the database name pattern.  Aborting this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15346,11,1,'This fallback server ''%s'' is already actively substituting for server ''%s''.  Aborting this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15347,11,1,'The databases enrolled for primary svr ''%s'' have varying version values.  Aborting this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15348,11,1,'At least one database enrolled for primary server ''%s'' is of version %d, but this fallback server ''%s'' requires version %d.  Aborting this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15349,11,1,'Activation of fallback by server ''%s'' for primary server ''%s'' will result in a  %s  name conflict.  Aborting this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15350,11,1,'A device lacks new fallback drive information.  Aborting this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15351,11,1,'@@fetch_status = %d during cursor ''%s''.  Rolling back and aborting.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15352,11,1,'This procedure is aborting due to the preceding error. (%s)',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15353,11,1,'This fallback server ''%s'' is not currently actively substituting for server ''%s'' for any databases matching the database name pattern.  Aborting this procedure.',NULL)

insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15355,16,1,'An error occurred trying to take database ''%s'' offline.  Investigate and rerun this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15356,0,1,'For primary server ''%s'', all databases matching the database name pattern have been deactivated, leaving them merely enrolled.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15357,0,1,'Action has been taken to correct an activation inconsistency in the spt_fallback_ tables.  The number of spt_fallback_ rows updated=%d.',NULL)

insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15359,11,1,'''%s'' is not known in sysservers as a fallback server.  Aborting this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15360,11,1,'Could not coalesce fragments on remote server ''%s''.  Aborting this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15361,11,1,'There is no database named ''%s'' in sysdatabases on server ''%s''.  Aborting this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15362,11,1,'The RPC for ''%s'' information failed.  Aborting this procedure.',NULL)

go

insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15364,11,1,'The server.database ''%s.%s'' is of version %d, but this fallback server ''%s'' requires version %d.  Aborting this procedure.',NULL)

insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15366,17,1,'WARNING, there is an integrity problem in the system tables! (%s , %d)',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15367,16,1,'Problem, there is an integrity problem within the spt_fallback_ tables. (%s , %d)',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15368,16,1,'Problem, there is a discrepancy within the spt_fallback_ tables regarding activation, for server ''%s''.',NULL)
Insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15369,16,1,'Problem, there is an activation discrepancy between the system tables and the spt_fallback_ tables, for server ''%s'' (%s).',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15370,11,1,'There are no actively supported databases for the primary server ''%s''.  Aborting this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15371,0,1,'Caution, the new drive specified (%s) is already actively being used in sysdevices by the Fallback server ''%s''.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15372,0,1,'Fallback drive data was updated for %d devices.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15373,0,1,'For primary server ''%s'',  %d databases were withdrawn from fallback enrollment, leaving %d still enrolled.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15374,0,1,'%d databases for primary server ''%s'' were activated.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15375,0,1,'The database ''%s'' was successfully enrolled on primary server ''%s'' for fallback/failover support.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15376,11,1,'The OVERRIDE option was not specified, so no action will be taken.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15377,0,1,'Some or all databases from primary server ''%s'' were successfully made permanent for server ''%s''.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15378,11,1,'No server may list more than one fallback server in its own sysservers table.  Aborting this procedure.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15379,11,1,'The server option value ''%s'' supplied is unrecognized.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15380,11,1,'The database ''%s'' is already enrolled from primary server ''%s''.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15381,16,1,'There is a uniqueness violation in spt_fallback_db, xserver_name=''%s'' dbid=%d.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15382,16,1,'There is a uniqueness violation in spt_fallback_dev, xserver_name=''%s'' low=%d.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15383,16,1,'There is a uniqueness violation in spt_fallback_usg, xserver_name=''%s'' vstart=%d.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15384,11,1,'All databases for the given server must be made permanent simultaneously, but not all of its enrolled databases are currently actively supported by fallback.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15385,11,1,'''%s'' is a special database which cannot be enrolled.',NULL)
go
--- (see sp_tableoption approx 15386-15392)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15386,11,1,'The value ''%s'' for input parameter @OptionName is not a recognized table option name.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15387,11,1,'If the qualified object name specifies a database, that database must be current database.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15388,11,1,'There are no objects matching the input name ''%s'' in the current database.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15389,11,1,'The value ''%s'' for the @OptionValue parameter is unrecognized.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15390,11,1,'Only the SA or DBO can modify ''%s'' settings for objects owned by other users.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15391,0,1,'All %d matched objects now have their ''%s'' setting as ''%s''.  Updates were required for %d objects.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15392,11,1,'Only the SA can modify the settings for table option ''%s''.',NULL)
insert into sysmessages (error ,severity ,dlevel ,description ,langid)
        values
	(15393,11,1,'The null value was used inappropriately for at least one input parameter.',NULL)
go

-------------------------------------------
/*
** The message range 16900 to 16999 is reserved for cursor related messages
*/
go
dump transaction master with no_log
go


print ' '
print 'Adding cursor messages.'
print ' '
go

insert into sysmessages values
	(16901,10,0,'%s:This feature has not been implemented yet.',NULL)
insert into sysmessages values
	(16902,10,0,'%s: The parameter %s is invalid.',NULL)
insert into sysmessages values
	(16903,10,0,'%s procedure called with incorrect number of parameters.',NULL)
insert into sysmessages values
	(16904,10,0,'The cursor handle is invalid.',NULL)
insert into sysmessages values
	(16905,10,0,'The cursor is already open.',NULL)
insert into sysmessages values
	(16906,10,0,'The cursor is not declared.',NULL)
insert into sysmessages values
	(16907,10,0,'%s is not allowed in cursor statements.',NULL)
insert into sysmessages values
	(16909,10,0,'%s: The cursor identifier value provided (%d) is not valid.',NULL)
insert into sysmessages values
	(16910,10,0,'%s: The fetch type %s can only be used with keyset driven cursors.',NULL)
insert into sysmessages values
	(16911,10,0,'%s: The fetch type %s cannot be used with forward only cursors.',NULL)
insert into sysmessages values
	(16912,10,0,'%s: This fetch type requires a rownumber.',NULL)
insert into sysmessages values
	(16914,10,0,'%s procedure called with too many parameters.',NULL)
insert into sysmessages values
	(16915,10,0,'A cursor with the name ''%s'' already exists.',NULL)
insert into sysmessages values
	(16916,10,0,'A cursor with the name ''%s'' does not exist.',NULL)
insert into sysmessages values
	(16917,10,0,'Cursor is not open.',NULL)
insert into sysmessages values
	(16919,10,0,'Cannot open cursor--referenced object (NAME NOT RECOVERABLE) dropped already.',NULL)
insert into sysmessages values
	(16920,10,0,'Stored procedure defining the cursor does not have a select statement.',NULL)
insert into sysmessages values
	(16921,10,0,'Cursorfetch: Must declare variable ''%s''.',NULL)
insert into sysmessages values
	(16922,10,0,'Cursorfetch: Variable type of ''%s'' does not match that of selected column in the cursor.',NULL)
insert into sysmessages values
	(16923,10,0,'Cursorfetch: Maximum length of ''%s'' is incompatible with that of selected column in the cursor.',NULL)
insert into sysmessages values
	(16924,10,0,'Cursorfetch: Number of variables declared in the INTO list must match that of selected columns.',NULL)
insert into sysmessages values
	(16925,10,0,'The fetch type %s cannot be used with dynamic cursors.',NULL)
insert into sysmessages values
	(16926,10,0,'sp_cursoroption: The column id (%d) does not correspond to a TEXT or IMAGE column.',NULL)
insert into sysmessages values
	(16927,10,0,'sp_cursoroption: The cursor already has a name.',NULL)
insert into sysmessages values
	(16928,10,0,'The column name ''%s'' specified in the FOR UPDATE list is invalid or ambiguous.',NULL)
insert into sysmessages values
	(16929,10,0,'Cursor is read only.',NULL)
insert into sysmessages values
	(16930,10,0,'Requested row is not in the fetch buffer.',NULL)
insert into sysmessages values
	(16931,10,0,'There are no rows in the current fetch buffer.',NULL)
insert into sysmessages values
	(16932,10,0,'Cursor has a ''FOR UPDATE'' list and the requested column to be updated is not in this list.',NULL)
insert into sysmessages values
	(16933,10,0,'The cursor does not include the table being modified.',NULL)
insert into sysmessages values
	(16934,10,0,'Optimistic concurrency check failed, the row was modified outside of this cursor.',NULL)
insert into sysmessages values
	(16935,10,0,'No values parameters were specified for the sp_cursor-%s command.',NULL)
insert into sysmessages values
	(16936,10,0,'Cannot open cursor-referenced object ''%s'' (ID %d) during %s.',NULL)
insert into sysmessages values
	(16937,10,0,'Cannot open a cursor on a stored procedure that has anything other than a single select statement in it.',NULL)
insert into sysmessages values
	(16938,10,0,'sp_cursoropen: The statement parameter can only be a single select or a single stored procedure.',NULL)
insert into sysmessages values
	(16939,10,0,'Process has isolation level set to 0 (uncommitted reads), which can only support READ ONLY cursors.',NULL)
insert into sysmessages values
	(16940,10,0,'Table optimizer hint ''%s'' is not allowed with READ ONLY cursors.',NULL)
insert into sysmessages values
	(16941,10,0,'Cursor updates are not allowed on tables opened with NOLOCK option.',NULL)
insert into sysmessages values
	(16942,10,0,'Asynchronous keyset generation failed, the cursor has been deallocated.',NULL)
insert into sysmessages values
	(16943,10,0,'Cursor open failed because the size of the keyset row exceeded maximum allowed row size.',NULL)
insert into sysmessages values
	(16944,10,0,'The unique index used for the table needs to have smaller number of keys or keys with smaller sizes.',NULL)
insert into sysmessages values
	(16945,10,0,'Cursor open failed because the size of the table row is too large for optimistic checking based on values.',NULL)
insert into sysmessages values
	(16946,10,0,'Try using locking, readonly or timestamp based optimistic checking for concurrency control on the table.',NULL)
insert into sysmessages values
	(16964,10,0,'Cursor has been closed after releasing its locks in order to resolve a deadlock situation.',NULL)

go

---------------------------------------------------

/*
** The message range 16800 to 16899 is reserved for Web Server messages
*/
print ' '
print 'Adding Web Server messages.'
print ' '
go

insert into sysmessages values (16801,11,0,"sp_dropwebtask requires at least one defined parameter @outputfile or @procname",NULL)
go
insert into sysmessages values (16802,11,0,"sp_dropwebtask can't find the specified task",NULL)
go
insert into sysmessages values (16803,11,0,"sp_runwebtask requires at least one defined parameter @outputfile or @procname",NULL)
go
insert into sysmessages values (16804,11,0,"SQL Web Assistant failed to initialize DB-Library",NULL)
go
insert into sysmessages values (16805,11,0,"SQL Web Assistant failed to open a dblib connection",NULL)
go
insert into sysmessages values (16806,11,0,"SQL Web Assistant failed to obtain a login record",NULL)
go
insert into sysmessages values (16807,11,0,"SQL Web Assistant failed to obtain a bind token",NULL)
go
insert into sysmessages values (16808,11,0,"SQL Web Assistant failed to intialize a dblib rpc call for sp_bindsession",NULL)
go
insert into sysmessages values (16809,11,0,"SQL Web Assistant failed a dblib dbrpcparam call for sp_bindsession ",NULL)
go
insert into sysmessages values (16810,11,0,"SQL Web Assistant failed a dblib dbrpcexec call for sp_bindsession ",NULL)
go
insert into sysmessages values (16811,11,0,"SQL Web Assistant failed a dblib dbresults call for sp_bindsession ",NULL)
go
insert into sysmessages values (16812,11,0,"SQL Web Assistant: @query parameter must be specified",NULL)
go
insert into sysmessages values (16813,11,0,"SQL Web Assistant: Parameters can either be passed by name or position",NULL)
go
insert into sysmessages values (16814,11,0,"SQL Web Assistant: Invalid parameter name or position",NULL)
go
insert into sysmessages values (16815,11,0,"SQL Web Assistant: @procname is not valid",NULL)
go
insert into sysmessages values (16816,11,0,"SQL Web Assistant: @outputfile is not valid",NULL)
go
insert into sysmessages values (16817,11,0,"SQL Web Assistant failed on dblib command dbsqlexec",NULL)
go
insert into sysmessages values (16818,11,0,"SQL Web Assistant failed on dblib command dbresults",NULL)
go
insert into sysmessages values (16819,11,0,"SQL Web Assistant failed on dblib command dbnextrow",NULL)
go
insert into sysmessages values (16820,11,0,"SQL Web Assistant failed because the state of web task in msdb..MSwebtasks is invalid",NULL)
go
insert into sysmessages values (16821,11,0,"SQL Web Assistant failed to open the output file",NULL)
go
insert into sysmessages values (16822,11,0,"SQL Web Assistant failed to open the template file",NULL)
go
insert into sysmessages values (16823,11,0,"SQL Web Assistant failed to allocate enough memory to satisfy this request",NULL)
go
insert into sysmessages values (16824,11,0,"SQL Web Assistant: The template file specified in the web task has a bad size",NULL)
go
insert into sysmessages values (16825,11,0,"SQL Web Assistant failed to read the template file",NULL)
go
insert into sysmessages values (16826,11,0,"SQL Web Assistant failed to find the specified marker for data insertion in the template file",NULL)
go
insert into sysmessages values (16827,11,0,"SQL Web Assistant failed to write to the output file",NULL)
go
insert into sysmessages values (16828,11,0,"SQL Web Assistant: @tabborder must be tinyint",NULL)
go
insert into sysmessages values (16829,11,0,"SQL Web Assistant: @singlerow must be 0 or 1",NULL)
go
insert into sysmessages values (16830,11,0,"SQL Web Assistant: @blobfmt parameter specification is invalid",NULL)
go
insert into sysmessages values (16831,11,0,"SQL Web Assistant: Output file name is mandatory for every column specified in the @blobfmt parameter",NULL)
go
insert into sysmessages values (16832,11,0,"SQL Web Assistant: Procedure called with too many parameters",NULL)
go
insert into sysmessages values (16846,11,0,"SQL Web Assistant: @unittype and/or @unittime must be specified for the given @whentype option",NULL)
go
insert into sysmessages values (16847,11,0,"SQL Web Assistant: @fixedfont must be 0 or 1",NULL)
go
insert into sysmessages values (16848,11,0,"SQL Web Assistant: @bold must be 0 or 1",NULL)
go
insert into sysmessages values (16849,11,0,"SQL Web Assistant: @italic must be 0 or 1",NULL)
go
insert into sysmessages values (16850,11,0,"SQL Web Assistant: @colheaders must be 0 or 1",NULL)
go
insert into sysmessages values (16851,11,0,"SQL Web Assistant: @lastupdated must be 0 or 1",NULL)
go
insert into sysmessages values (16852,11,0,"SQL Web Assistant: @HTMLheader must be in the range 1-6",NULL)
go
insert into sysmessages values (16853,11,0,"SQL Web Assistant: @username is not valid",NULL)
go
insert into sysmessages values (16854,11,0,"SQL Web Assistant: @dbname is not valid",NULL)
go
insert into sysmessages values (16855,11,0,"SQL Web Assistant: @whentype must be in the range 1-9",NULL)
go
insert into sysmessages values (16856,11,0,"SQL Web Assistant: @unittype must be in the range 1-4",NULL)
go
insert into sysmessages values (16857,11,0,"SQL Web Assistant: @targetdate must be greater than or equal to 19000101",NULL)
go
insert into sysmessages values (16858,11,0,"SQL Web Assistant: @targettime must be greater than or equal to 0",NULL)
go
insert into sysmessages values (16859,11,0,"SQL Web Assistant: @dayflags must be one of 1, 2, 4, 8, 16, 32, or 64",NULL)
go
insert into sysmessages values (16860,11,0,"SQL Web Assistant: @numunits must be greater than 0",NULL)
go
insert into sysmessages values (16861,11,0,"SQL Web Assistant: @targetdate must be specified for the given @whentype option",NULL)
go
insert into sysmessages values (16862,11,0,"SQL Web Assistant: @dayflags must be specified for the given @whentype option",NULL)
go
insert into sysmessages values (16863,11,0,"SQL Web Assistant: URL specification is invalid ",NULL)
go
---------------------------------------------------


go

print ' '

SELECT 'Num sysmessages rows After  the many Inserts:',count(*) from sysmessages
SELECT 'MIN/MAX(error) in sysmessages After  the many Inserts:',MIN(error) 'MIN_error',MAX(error) 'MAX_error' from sysmessages

go


UPDATE
             sysmessages
      set
             dlevel = isnull( (SELECT  dlevel
                                 from  #dsave
                                 where error  = sysmessages.error
                                 and   langid = sysmessages.langid
                              ) ,0
                            )
go

IF object_id('tempdb..#dsave') IS NOT Null
                    drop table #dsave
go

go
dump transaction master with no_log
go

if exists (select * from sysobjects where name = 'sp_configure'
			and sysstat & 0xf = 4)
	begin
		exec sp_configure 'allow updates',0
		reconfigure with override
	end
go

declare @vdt varchar(99)
select  @vdt = convert(varchar,getdate(),113)
raiserror('
Finishing Install\Messages.SQL at  %s',0,1,@vdt)
go

dump transaction master with no_log
go
checkpoint
go
-- -
