/* LAST MODIFIED DATE: 09/25/97 */
/* # %Z%   generic/scripts/%M% %I% %G%  */

set nocount on
go
use master
go
dump tran master with no_log
go
declare @size int
	select @size = (2048 - sum(size)) / 512
	from sysusages where dbid = 1
if (@size = 1)
begin
	alter database master on master = 1
end
else if (@size = 2)
begin
	alter database master on master = 2
end
go
if exists (select 1
	from sysobjects
		where name = 'sp_configure'
			and sysstat & 7 = 4)
begin
	execute sp_configure 'update', 1
end
reconfigure with override
go


/* do regular processing */

/*
**	sysmsgs.ebf is designed to correct the sysmessages table
**	in the master database.  It modifies/add messages in sysmessages.
**
**	Each english mesg is inserted/modified  using the stored procedure
** 	"sp_us_mesg" which is created at the start of the script and
**	dropped at the end.
**
**	English messages should be added in the ENGLISH message section.
**	Foreign messages should be added to the CORRESPONDING FOREIGN language
**	 	section.
**	The messages should not have LINEFEED(LF/CR) sequencer in between. 
**	If it spans beyond the current line just keep typing so that it will
**	wrap around.

**	sp_us_mesg error, severity, "text of message in double quotes, with no imbedded newlines.  That is, let the line wrap."
**
**	For example:
**
**	sp_us_mesg 4210, 16, "While attempting DUMP TRANsaction WITH NO_TRUNCATE, couldn't find database %.*s."
**
**
**
**	Each foreign language mesg is inserted/modified using the stored 
**	procedure "sp_addlimsg" which is created at the start of the script
**	and dropped at the end.
**	
**	
*/
use master
go
/*
** Add the sp_us_mesg stored procedure
*/
if exists (select * from sysobjects where name = 'sp_us_mesg' and type = 'P')
begin
	drop procedure sp_us_mesg
end
go

/* CREATE PROCEDURE SP_US_MESG */
create procedure sp_us_mesg
	@error_number int,
	@severity_number int,
	@message_text varchar(255)
as
declare @retval int
declare @fmtbuf varchar(255)
set nocount on
select @retval = 0
select @retval = (select 1 
		     from sysmessages 
			where error = @error_number and langid is NULL
		  )
/* message is not available so insert it. */
if (@message_text != NULL)
	begin
	if (@retval = 1) 
		begin
		select @fmtbuf = (select "Modifying Message: " 
			+ convert(varchar(8),@error_number) + " Severity: " 
			+ convert(varchar(8),@severity_number))
		print @fmtbuf
		begin tran
		update sysmessages 
			set error=@error_number,
			severity=@severity_number,
			dlevel=2,	/* dlevel is always 2 */
			description=@message_text,
			langid=NULL	/* messages are shipped in English. */
			where langid is NULL and error=@error_number
		commit tran
		end
	else
		begin
		select @fmtbuf = "Adding Message: "
			+ convert(varchar(8),@error_number) + " Severity: "
			+ convert(varchar(8),@severity_number)
		print @fmtbuf
		begin tran
		insert sysmessages values (
			@error_number,
			@severity_number,
			2,		/* dlevel is always 2 */
			@message_text,
			NULL,
			NULL)		/* messages are shipped in English. */
		commit tran
		end
	end
go


/* ==================================sp_addlimsg============================ */

if exists (select * from sysobjects where name = 'sp_addlimsg' and type = 'P')
begin
	drop procedure sp_addlimsg
end
go


/* CREATE PROCEDURE sp_addlimsg */

create procedure sp_addlimsg
		(
		@error		int,		/* Error being installed. */
		@message	varchar(255),	/* Text of new message.   */
		@langid		int,		/* Message's language ID. */
		@debug		bit = 0		/* Turned on for debug.   */
		)
as

/*	Variable declarations.		*/

declare	@oldseverity	int,		/* Old message severity.	*/
	@olddlevel	int, 		/* Old message dlevel.		*/
	@olddesc	varchar(255),	/* Old message text.		*/
	@engseverity	int,		/* English message severity.	*/
	@engdlevel	int,		/* English message dlevel.	*/
	@engdesc	varchar(255),	/* English message text.	*/
	@tstr		varchar(255),	/* Temporary string holder.	*/
	@strlength	int,		/* Temporary string length var.	*/
	@remaining	int,		/* Length of string remaining.	*/
	@cindex		int,		/* Temporary charindex holder.	*/
	@pindex		int,		/* Temporary parameter count.	*/
	@tindex		int,		/* Temporary copy of cindex.	*/
	@engcount	int,		/* English message param count.	*/
	@newcount	int,		/* New message param count.	*/
	@debugmsg	varchar(255),	/* Debug message string.	*/
	@maxparams	int		/* Maximum number of params.	*/

/*	Initialize variables that are used as #DEFINE type constants.	*/

select	@maxparams = 12		/* Maximum number of params in a msg.	*/
				/* this value comes from ex_print.c	*/
if @debug = 1
	begin
	select	@debugmsg = "Starting message "
		+ convert( varchar, @error )
		+ "."
	print @debugmsg
	end	/* IF DEBUG	*/

/*	Get the English message from sysmessages.	*/

select	@engseverity = severity, @engdlevel = dlevel,
	@engdesc = description
	from sysmessages
	where error = @error
	  and langid is NULL

if @debug = 1
	begin
	select	@debugmsg = "English message:  severity = "
		+ convert( varchar, @engseverity )
		+ ", dlevel = "
		+ convert( varchar, @engdlevel )
		+ ", description follows -- "
	print @debugmsg
	print @engdesc
	end	/* IF DEBUG	*/

/*
**	If there is no English message, and the stored procedure is not
**	being asked to delete the equivalent translated message, then
**	there is a problem; there should not be a translation when there
**	is no English equivalent!
*/

if @engseverity is NULL and @message != "delete"
	return 7	/* 7 = no English equivalent.	*/

/*	Get the old translated version of the message.	*/

select	@oldseverity = severity, @olddlevel = dlevel,
	@olddesc = description
	from sysmessages
	where error = @error
	  and langid = @langid

if @debug = 1
	begin
	select	@debugmsg = "Old message:  severity = "
		+ convert( varchar, @oldseverity )
		+ ", dlevel = "
		+ convert( varchar, @olddlevel )
		+ ", description follows -- "
	print @debugmsg
	print @olddesc
	end	/* IF DEBUG	*/

/*
**	Check to see if we are being asked to delete a message; if so,
**	we can skip all the rest of the processing and just perform the
**	delete.  If there is an English version of the message, then
**	indicate that we are (in essence) replacing the translated version
**	with an English one.  Also check to see if it is actually
**	necessary to perform the delete (i.e., if there is a message
**	to delete).
*/
/* =========================BEGIN add_LImsg3=============================*/

if @message =  "delete"
	begin

	if @oldseverity is NULL		/* No old version of msg.	*/
		return 3		/* 3 = already installed.	*/

	else	begin			/* Old version exists.		*/
		delete	from sysmessages
			where error = @error
			  and langid = @langid
		if @@error != 0
			return 10	/* 10 = delete failed.		*/
		if @engseverity is NULL
			return 4	/* 4 = message deleted.		*/
		else	return 5	/* 5 = message replaced by Eng.	*/
		end	/* ELSE	*/

	end	/* IF	*/

/*
**	Having reached this point, we know that we are going to insert
**	or update a message.  Therefore, we check to be sure that the
**	new message has the same number of parameters as the English
**	version, and that the parameters are numbered appropriately.
**	We don't check the order of the parameters, because word order
**	varies from one language to another.
*/

if @debug = 1
	print "Searching English message for parameters."

/*	Initialize variables, get parameter 1.		*/

select	@tstr = "%"
select	@cindex = charindex( @tstr, @engdesc ),
	@pindex = 0, @strlength = datalength( @engdesc )
	/* @pindex = 0, @strlength = datalength( @engdesc ) */

if @cindex = 0
	select	@remaining = 0
else	select	@remaining = @strlength - @cindex

/* =========================BEGIN add_LImsg4==============================*/

if @debug = 1
	begin
	select	@debugmsg = "Values:  CINDEX = "
		+ convert( varchar, @cindex )
		+ ", PINDEX = "
		+ convert( varchar, @pindex )
		+ ", STRLENGTH = "
		+ convert( varchar, @strlength )
		+ ", REMAINING = "
		+ convert( varchar, @remaining )
		+ "."
	print @debugmsg
	end	/* IF DEBUG	*/

/*
**	Keep getting parameters until there are no more.  We assume
**	that the English version has the correct number of parameters.
*/

while @cindex != 0
	begin

	if @cindex = @strlength	/* Single percent sign is last char.	*/
		return 14	/* 14 = Corrupted English message.	*/

	if "%" =		/* Look for escaped % characters (%%).	*/
		(
		select	substring( @engdesc, @cindex+1, 1 )
		)
		begin

		if @debug = 1
			begin
			select	@debugmsg = "Escaped percent sign string "
				+ "'%%' found at character "
				+ convert( varchar, @cindex )
				+ "."
			print @debugmsg
			end	/* IF DEBUG	*/


		select	@cindex = @cindex + 2,
			@remaining = ( @strlength - @cindex )

		if @cindex > @strlength
			break	/* '%%' at end of string, exit WHILE loop */

		select	@tindex = charindex( @tstr,
			substring( @engdesc, @cindex, @remaining+1 ) )

		if @tindex = 0
			select @cindex = 0		/* No more parameters.	*/
		else	
			/* Potential parameter found. */
			select @cindex = @cindex + @tindex - 1,
			@remaining = @strlength - @cindex

		if @debug = 1
			begin
			select	@debugmsg = "Values:  CINDEX = "
				+ convert( varchar, @cindex )
				+ ", PINDEX = "
				+ convert( varchar, @pindex )
				+ ", STRLENGTH = "
				+ convert( varchar, @strlength )
				+ ", REMAINING = "
				+ convert( varchar, @remaining )
				+ "."
			print @debugmsg
			end	/* IF DEBUG	*/

		continue	/* Return to beginning of WHILE loop.	*/

		end	/* IF	*/


/* =========================BEGIN add_LImsg5=============================*/

	if @debug = 1
		begin
		select	@debugmsg = "Parameter found at character "
			+ convert( varchar, @cindex )
			+ "."
		print @debugmsg
		end	/* IF DEBUG	*/

	/*	Found a valid parameter.	*/

	select	@pindex = @pindex + 1	/* Increment parameter count. */

	if @debug = 1
		begin
		select	@debugmsg = "Values:  CINDEX = "
			+ convert( varchar, @cindex )
			+ ", PINDEX = "
			+ convert( varchar, @pindex )
			+ ", STRLENGTH = "
			+ convert( varchar, @strlength )
			+ ", STRLENGTH remaining = "
			+ convert( varchar, @remaining )
			+ "."
		print @debugmsg
		end	/* IF DEBUG	*/

	/*	Continue searching from current string location on.	*/

	select	@tindex = @cindex + charindex( @tstr,
			substring( @engdesc, @cindex+1, @remaining ) )

	if @cindex = @tindex
		select @cindex = 0		/* No more parameters.	*/
	else	select @cindex = @tindex	/* Potential parameter found. */

	select	@remaining = @strlength - @cindex

	end	/* WHILE	*/

/*	Store the number of parameters.		*/

/* =========================BEGIN add_LImsg6==============================*/

select	@engcount = @pindex

if @debug = 1
	begin
	select	@debugmsg = "Number of parameters in English message was "
		+ convert( varchar, @engcount )
		+ "."
	print @debugmsg
	end	/* IF DEBUG	*/

/*
**	Now perform the same count on the new message to ensure that
**	it has the same number of parameters as the English equivalent.
**	Also, check that the new message does not skip any parameter
**	numbers.
*/

if @debug = 1
	print "Searching translated message for parameters."

/*	Ensure there is no zero-eth parameter.	*/

if 0 !=
	(
	select	charindex( "%0!", @message )
	)
	return 12	/* 12 = format error; parameter 0 found. */

select	@tstr = "%1!"

select	@cindex = charindex( @tstr, @message ),
	@pindex = 0, @tindex = 0, @strlength = datalength( @message )
	/* @pindex = 0, @tindex = 0, @strlength = datalength( @message ) */

/*=========================BEGIN add_LImsg7==================================*/

if @debug = 1
	begin
	select	@debugmsg = "Values:  CINDEX = "
		+ convert( varchar, @cindex )
		+ ", PINDEX = "
		+ convert( varchar, @pindex )
		+ ", STRLENGTH = "
		+ convert( varchar, @strlength )
		+ "."
	print @debugmsg
	end	/* IF DEBUG	*/

while @cindex != 0	/* Got one!	*/
	begin

	if @debug = 1
		begin
		select	@debugmsg = "Parameter '"
			+ @tstr
			+ "' found at character "
			+ convert( varchar, @cindex )
			+ "."
		print @debugmsg
		end	/* IF DEBUG	*/

	/*	Make sure that the parameter number appears only once.	*/

	if 0 !=
		(
		select	charindex( @tstr,
				substring( @message, @cindex+1,
				@strlength-@cindex ) )
		)
		return 13	/* 13 = format error; duplicate parameter. */

	select	@pindex = @pindex + 1	/* Increment number found.	*/
	select	@tstr = "%"
		+ convert( varchar, @pindex+1 )	/* Next one to look for. */
		+ "!"

	select	@cindex = charindex( @tstr, @message )	/* Search!	*/

/*=========================BEGIN add_LImsg8==================================*/

	if @debug = 1
		begin
		select	@debugmsg = "Values:  CINDEX = "
			+ convert( varchar, @cindex )
			+ ", PINDEX = "
			+ convert( varchar, @pindex )
			+ ", STRLENGTH = "
			+ convert( varchar, @strlength )
			+ "."
		print @debugmsg
		end	/* IF DEBUG	*/

	end	/* WHILE	*/

select	@newcount = @pindex

if @debug = 1
	begin
	select	@debugmsg = "Highest parameter number was "
		+ convert( varchar, @newcount )
		+ "."
	print	@debugmsg
	end	/* IF DEBUG	*/

select	@pindex = @pindex + 1	/* Skip over n+1 parameter.	*/

/*	Ensure that no parameter number was skipped.	*/

if @debug = 1
	print "Searching new message for skipped parameter numbers."

while ( @pindex < @maxparams )
	begin

	select	@pindex = @pindex + 1	/* Next number to look for.	*/
	select	@tstr = "%"
		+ convert( varchar, @pindex )
		+ "!"

/*=========================BEGIN add_LImsg9==================================*/

	select	@cindex = charindex( @tstr, @message )	/* Search!	*/

	if @debug = 1
		begin
		select	@debugmsg = "Values:  CINDEX = "
			+ convert( varchar, @cindex )
			+ ", PINDEX = "
			+ convert( varchar, @pindex )
			+ ", STRLENGTH = "
			+ convert( varchar, @strlength )
			+ "."
		print @debugmsg
		end	/* IF DEBUG	*/

	if @cindex != 0			/* Found a match.	*/
		return 11		/* 11 = message format error.	*/

	end	/* WHILE	*/

/*	Now see if the parameter counts match.		*/

if @engcount != @newcount
	return 6		/* 6 = format count mismatch.	*/

/*
**	Okay to proceed.  Now check to see if the new message is a
**	duplicate of the message it is supposed to replace.  We need
**	to check severity and dlevel as well as the message text,
**	because the upgrade may be to one of those values rather than
**	the string itself.
*/

if @oldseverity is not NULL
	and @olddesc = @message
	and @oldseverity = @engseverity
	and @olddlevel = @engdlevel
	return 3		/* 3 = message already installed.	*/

/*
**	If we are here, it is not a complete duplicate, so it must
**	either be a new message or a replacement message.
*/


/*=========================BEGIN add_LImsg10=================================*/

if @oldseverity is not NULL	/* Replacement message.	*/
	begin

	update	sysmessages
		set	severity = @engseverity,
			dlevel = @engdlevel,
			description = @message
		where	error = @error
		  and	langid = @langid

	if @@error != 0
		return 9	/* 9 = update failed.	*/

	return 2		/* 2 = message updated.	*/

	end

/*	If we are here, then it is a new message.	*/

insert	into sysmessages
		(
		error, severity, dlevel, langid, description
		)
	values	(
		@error, @engseverity, @engdlevel, @langid, @message
		)

if @@error != 0
	return 8		/* 8 = insert failed.	*/

return 1			/* 1 = message inserted.	*/ 
go

/*                      --------------------------------                      */
/* ====================        DONE WITH SQL TEXT        ==================== */
/* ==================== BEGIN ACTUAL CODE FOR new_msgs() ==================== */
/*                      --------------------------------                      */

/* ==================================sp_oth_mesg============================ */

if exists (select * from sysobjects where name = 'sp_oth_mesg' and type = 'P')
begin
	drop procedure sp_oth_mesg
end
go


/* CREATE PROCEDURE sp_oth_mesg */

create procedure sp_oth_mesg 
		(
		@error 		int,		/* Error being installed. */
		@message	varchar(255),	/* Text of new message. */
		@langname	varchar(255)	/* language name */
		)
as	

/* Variable declarations */
declare @retval	int	/* return value */
declare @msg varchar(255)
declare @langid int


set nocount on
select @retval = 0
select @langid = langid from syslanguages where name = @langname
if @langid is NULL
begin
	select @msg = convert(varchar(8),@langname) + " language is not installed"
	print @msg
	return 0
end
exec @retval = sp_addlimsg @error,@message,@langid

if @retval = 1
begin
	select @msg = "Added Message #" + convert(varchar(6),@error) + " for " + @langname + " language"
	print @msg
end
else if @retval = 2
begin
	select @msg = "Updated Error #" + convert(varchar(6),@error) + " for " + @langname + " language"
	print @msg
end
else if @retval = 3
begin
	select @msg = "Message #" + convert(varchar(6),@error) + " not found in database for delete for" + @langname + " language"
	print @msg
end
else if @retval = 4
begin
	select @msg = "Deleted message #" + convert(varchar(6),@error) + " from " + @langname  + " language"
	print @msg
end
else if @retval = 5
begin
	select @msg = "Deleted message #" + convert(varchar(6),@error) + " from " + @langname + " language"
	print @msg
end
else if @retval = 6
begin	
	select @msg = "Format count of + @langname" + " message #" + convert(varchar(6),@error) + " does not match English message" 
	print @msg
end
else if @retval = 7
begin
	select @msg = "English Message Not found for + message #" + convert(varchar(6),@error)
	print @msg
end
else if @retval = 8
begin
	select @msg = "Insert failed for message #" + convert(varchar(6),@error) + " for " + @langname + " language"
	print @msg
end
else if @retval = 9
begin
	select @msg = "Update failed for message #" + convert(varchar(6),@error) + " for " + @langname + " language"
	print @msg
end
else if @retval = 10
begin
	select @msg = "Delete failed for message #" + convert(varchar(6),@error) + " for " + @langname + " language"
	print @msg
end
else if @retval = 11
begin
	select @msg = "Skipped parameter number in message #"+convert(varchar(6),@error) + " for " + @langname + " language"
	print @msg
end
else if @retval = 12
begin
	select @msg = "Illegal parameter 0 found in message #"+convert(varchar(6),@error) + " for " + @langname + " language"
	print @msg
end
else if @retval = 13
begin
	select @msg = "Duplicate parameter found in message #"+convert(varchar(6),@error) + " for " + @langname + " language"
	print @msg
end
else if @retval = 14
begin
	select @msg = "English message is corrupted for message #"+convert(varchar(6),@error)
	print @msg
end
else
begin
	select @msg = "Bad return code"
	print @msg
end
go
	

/* ==================================sp_oth_mesg============================ */



/*
** ======================= ENGLISH MESSAGE AREA ==============================
** ===========================================================================
** ENGLISH MESSAGE AREA. USE "sp_us_mesg" to add message
** exec sp_us_mesg <error>,<severity>,<message_with_no_linefeed>
**
** SAMPLE ENGLISH MESG
** exec sp_us_mesg 9999,20,"Testing english message"
** go
*/

exec sp_us_mesg 317, 16, "A subquery in this query is correlated to an inner table of an outerjo\
in. This is not allowed in TSQL semantics."
go

exec sp_us_mesg 420, 16, "TEXT and IMAGE columns can not appear in the select list or ORDER BY c\
olumn list in a query having ORDERY BY clause."
go

exec sp_us_mesg 443, 16, NULL
go

exec sp_us_mesg 539, 20, "Access methods error code %d encountered but run does not know how to \
handle it: spid = %d, dbid = %d, objectid = %ld, curcmd = %d (%s), pla\
sterror = %ld, pstat = 0x%x, p2stat = 0x%x, pattention = %ld, xact id \
= (%ld, %d)."
go

exec sp_us_mesg 629, 21, "Clustered index row entry for data page %ld is missing in index page %\
ld of table '%S_OBJID' in database '%S_DBID'; index row contains data \
page %ld instead. You can re-create the clustered index to fix this er\
ror. Xactid is (%ld,%d)."
go

exec sp_us_mesg 644, 21, "Index row entry for data row id (%ld, %d) is missing from index page %\
ld of index id %d of table '%S_OBJID' in database '%S_DBID'. Xactid is\
 (%ld,%d). Drop and re-create the index."
go

exec sp_us_mesg 685, 21, "Expected page %ld to be in cache '%.*s' for object id %ld, index id %d\
, database id %d. Instead, the server brought the page into wrong cach\
e '%.*s'."
go

exec sp_us_mesg 691, 20, "Encountered invalid logical page '%ld' while accessing object '%ld' in\
 database '%d'. This is an internal system error. Please contact Sybas\
e Technical Support."
go

exec sp_us_mesg 691, 20, "Encountered invalid logical page '%ld' while accessing object '%ld' in\
 database '%d'. This is an internal system error. Please contact Sybas\
e Technical Support."
go

exec sp_us_mesg 692, 20, "Uninitialized logical page '%ld' was read while accessing object '%ld'\
 in database '%d'. Please contact Sybase Technical Support."
go

exec sp_us_mesg 693, 20, "Multiple copies of logical page '%ld' from database '%d' reside in mor\
e than one cache. This is an internal system error. Please contact Syb\
ase Technical Support."
go

exec sp_us_mesg 694, 24, "An attempt was made to read logical page '%ld', virtpage '%ld' from vi\
rtual device '%d' for object '%ld' in database '%d'. The page was not \
read successfully. You may have a device problem or an operating syste\
m problem."
go

exec sp_us_mesg 695, 21, "An attempt was made to read logical page '%ld' for object '%ld' in dat\
abase '%d' from disk. Wrong logical page '%ld' was brought into cache \
'%.*s'."
go

exec sp_us_mesg 696, 21, "An attempt was made to fetch logical page '%ld' in tempdb from cache '\
%.*s'. Page belongs to object '%ld' and not to object '%ld'. Restart o\
f SQL Server will clear the error. Please contact your System Administ\
rator for help."
go

exec sp_us_mesg 697, 21, "An attempt was made to fetch logical page '%ld' for object '%ld' in da\
tabase '%d' from cache '%.*s'. Wrong logical page '%ld' was found in c\
ache."
go

exec sp_us_mesg 698, 21, NULL
go

exec sp_us_mesg 699, 21, NULL
go

exec sp_us_mesg 835, 21, "Illegal attempt to change contents of buffer: %S_BUF, xact id = (%ld, \
%d)."
go

exec sp_us_mesg 875, 20, "Could not grab a buffer to allocate a new page for log in database id \
%d. Tried %d buffers, all the buffers in the wash section are pinned t\
o Privale Log Cache. See errorlog for more information."
go

exec sp_us_mesg 876, 20, "The process is holding log semaphore on database %d and is about to sl\
eep on mass=0x%x with stat=0x%x for page=%ld which is being written by\
 some other process that needs the log semaphore. This causes a deadlo\
ck, and can only be cleared by a reboot."
go

exec sp_us_mesg 877, 0, "A previous operation marked the '%ldK' pool in the '%.*s' cache as bei\
ng too small and therefore not available for use. To increase the pool\
 size first delete it using sp_poolconfig."
go

exec sp_us_mesg 945, 21, "Unable to locate page %ld for database id %d in the in-memory copy of \
Sysusages (spid=%ld). This is an internal error. Please contact Sybase\
 Technical Support."
go

exec sp_us_mesg 953, 11, "Page '%ld', passed to curunreservedpgs built-in function, is an invali\
d page number in database ID '%d'. The highest page number in this dat\
abase is '%ld'."
go

exec sp_us_mesg 1131, 22, "The OAM for object %ld, index %d, oam page %ld, database=%d, is curren\
tly allocated to another object."
go

exec sp_us_mesg 1142, 22, "Invalid OAM Page %ld. Found pstat=0x%x, object=%ld, database=%d, indid\
=%d."
go

exec sp_us_mesg 1143, 22, "Invalid OAM Page %ld. Expected object=%ld. Found object=%ld, database=\
%d, pstat=0x%x, indid=%d."
go

exec sp_us_mesg 1608, 18, "A client process exited abnormally, or a network error was encountered\
. Unless other errors occurred, continue processing normally."
go

exec sp_us_mesg 1816, 16, "CREATE/ALTER DATABASE failed because the log device '%.*s' has no spac\
e available."
go

exec sp_us_mesg 1931, 16, "You cannot re-create the same non-clustered index (ID %d) for object I\
D %ld in database '%.*s' because you dropped it twice in a single tran\
saction. Transaction rolled back."
go

exec sp_us_mesg 1932, 16, "You cannot re-create the same clustered index for object ID %ld in dat\
abase '%.*s' more than once in a single transaction. Transaction rolle\
d back."
go

exec sp_us_mesg 2510, 16, "Key mismatch between index page %ld (row %d) and data page %ld in data\
base '%.*s'. Drop and re-create index id %d of table '%.*s'."
go

exec sp_us_mesg 2511, 16, "Keys of index id %d for table '%.*s' in %S_MSG %ld should be in ascend\
ing order. Drop and re-create the index in database '%.*s'."
go

exec sp_us_mesg 2537, 10, "Checking %ld."
go

exec sp_us_mesg 2537, 16, "Table with ID %ld not found; check sysobjects."
go

exec sp_us_mesg 2537, 10, "Checking %ld."
go

exec sp_us_mesg 2565, 14, "Only the DBO of database %S_DBID or a user with System Administrator (\
SA) role can run DBCC '%.*s'."
go

exec sp_us_mesg 2586, 16, "The last key in the previous page (%S_PAGE) is equal to the first key \
in the current page (%S_PAGE); however, the status of previous page in\
dicates that there is no overflow page."
go

exec sp_us_mesg 2610, 22, "Could not find leaf row in nonclustered index '%.*s' page %ld that cor\
responds to data row from logical data page %ld, row offset %d during \
update index attempt after data page split in dbid %d."
go

exec sp_us_mesg 2619, 20, "Keys did not match overflow page when inserting row at end of page (%S\
_PAGE) that has overflow page (%S_PAGE) that is not disconnected in db\
id = %d."
go

exec sp_us_mesg 3121, 16, "Index %s.%s (objid=%ld, indid=%d) may be invalid. It uses CHAR or VARC\
HAR columns in its key and was created under a different sort order ID\
 (%d) or charset ID (%d) than the ones on this server (SortOrd=%d, Cha\
rSet=%d)."
go

exec sp_us_mesg 3307, 21, "Process %d was expected to hold logical lock on page %ld in database %\
S_DBID for object %S_OBJID, index number %d."
go

exec sp_us_mesg 3313, 10, "Error while redoing log row in database '%S_DBID'. %S_RID."
go

exec sp_us_mesg 3314, 10, "Error while undoing log row in database '%.*s'. %S_RID."
go

exec sp_us_mesg 3733, 10, "The drop command is bypassing deletion of a cross-database constraint \
catalog entry in database '%.*s' because the database does not exist. \
The drop command will execute successfully (assuming no further errors\
 in processing)."
go

exec sp_us_mesg 3733, 10, "Warning: There is an invalid cross-database reference in system catalo\
g, the referenced database '%.*s' does not exist."
go

exec sp_us_mesg 3734, 10, "The drop command is ignoring a reference by another database '%.*s' be\
cause the database is non-existent. The drop command will execute succ\
essfully (assuming no further errors in processing the drop command)."
go

exec sp_us_mesg 3734, 10, "Warning: There is an invalid cross-database reference in system catalo\
g, the referencing database '%.*s' does not exist."
go

exec sp_us_mesg 3735, 10, "Warning: There is an invalid cross-database reference in system catalo\
g, a referenced table, id %d in database '%.*s' does not exist."
go

exec sp_us_mesg 3736, 10, "The drop command is ignoring a missing referential constraint catalog \
entry in database '%.*s'. The command will execute successfully (assum\
ing no further errors in processing)."
go

exec sp_us_mesg 3736, 10, "Warning: There is a missing referential constraint catalog entry in da\
tabase '%.*s'."
go

exec sp_us_mesg 3741, 16, "Cannot drop object '%.*s' because it is tagged as partitioned (# of sl\
ices=%ld) although it shouldn't."
go

exec sp_us_mesg 4231, 16, "DUMP TRANSACTION is not allowed as the previous attempt to dump the da\
tabase was terminated before the dump completed. Dump the database wit\
h DUMP DATABASE. Then retry DUMP TRANSACTION."
go

exec sp_us_mesg 4232, 16, NULL
go

exec sp_us_mesg 4426, 16, "This query cannot be processed because it contains TEXT/IMAGE columns \
and references a view defined with a subquery, an outer join, or a dis\
tinct clause."
go

exec sp_us_mesg 4839, 18, "Server has encountered badly formatted rows from bulk copy. Could not \
locate the row position reserved for the insertion of the identity val\
ue."
go

exec sp_us_mesg 4839, 18, "Server has encountered badly formatted rows from bulk copy. Could not \
locate the row position reserved for the insertion of the identity val\
ue."
go

exec sp_us_mesg 5033, 16, "Attempt to alter database '%S_DBID' failed because it is in read-only \
mode."
go

exec sp_us_mesg 7143, 18, "The maxlen field of non-TEXT/IMAGE constant node is non-zero. Wrong da\
ta length may be reported."
go

exec sp_us_mesg 7243, 16, "Internal Limit reached. All local LOGCONN array segments are full. The\
 following display is accurate, but it does not contain all active LOG\
CONNs. Displaying %d active LOGCONNs in %d local arrays."
go

exec sp_us_mesg 7408, 16, "Could not find a dbtable for database %d."
go

exec sp_us_mesg 7427, 10, "Failed to complete LCT_ADMIN() function. Please look for any previous \
messages that may help identify the cause."
go

exec sp_us_mesg 7430, 16, "The unsuspend option is disabled. To free log space, terminate the lon\
gest running transaction in this database."
go

exec sp_us_mesg 7431, 16, "To resolve the problem, locate the spid of the longest running transac\
tion in master..syslogshold. Terminate that session so that you can du\
mp the transaction log and free up log space."
go

exec sp_us_mesg 7432, 14, "Unable to complete lct_admin() as it failed during protection check."
go

exec sp_us_mesg 7756, 16, "Unable to SET IDENTITY_INSERT to ON/OFF for table '%.*s' because the t\
able does not have the identity property."
go

exec sp_us_mesg 7930, 16, "Table Corrupt: key(s) in the left child is not less than the parent ke\
y; check left child page %ld of index id %d for table '%.*s' in databa\
se '%.*s'."
go

exec sp_us_mesg 7931, 16, "Table Corrupt: key(s) in the right child is less than the parent key; \
check right child page page %ld of index id %d for table '%.*s' in dat\
abase '%.*s'."
go

exec sp_us_mesg 8201, 26, "Keep count of descriptor (objid=%ld, dbid=%d) was expected to be %d. I\
nstead %d was found."
go

exec sp_us_mesg 8438, 21, "Updating wrong indexrow in dbid %d. Objid for actual row updated is %l\
d, objid for intended row was %ld. Index id for intended row was %d. I\
ndex page is %ld, field updated is %d. Index row address is %0x, row n\
umber is %d."
go

exec sp_us_mesg 9101, 16, "The total size of all parameter values for stored procedure '%.*s' exc\
eeds maximum size (%d bytes) allowed for replication. Stored procedure\
 '%.*s' is not replicated."
go

exec sp_us_mesg 9802, 20, "Deletion of row in SYSPARTITIONS failed. Database id %d, Object id %d,\
 Partition number %d."
go

exec sp_us_mesg 9803, 21, "Missing row in SYSPARTITIONS. Database id %d, Object id %d, Partition \
number %d."
go

exec sp_us_mesg 9805, 10, "Partition number %d for object id %d in database %d does not exist."
go

exec sp_us_mesg 9807, 20, "Process %d encountered deadlock while trying to lock control page %d o\
f partition %d for object id %d."
go

exec sp_us_mesg 9809, 21, "Control page %d specified for partition number %d of object id %d in d\
atabase %d does not exist."
go

exec sp_us_mesg 9810, 21, "Control page %d specified for partition number %d for object id %d in \
database %d is corrupt."
go

exec sp_us_mesg 9814, 21, "SYSPARTITIONS table is missing in database %d."
go

exec sp_us_mesg 9816, 17, "Unable to allocate an in-memory partition structure for object id %d i\
n database %d. To increase the number of available partitions update t\
he 'partition groups' configuration parameter."
go

exec sp_us_mesg 9938, 16, "Table with ID %ld not found; check sysobjects."
go

exec sp_us_mesg 9939, 16, "DBCC %s command is not supported anymore."
go

exec sp_us_mesg 10235, 10, "The cursor was closed because the object associated with it has been d\
ropped."
go

exec sp_us_mesg 10606, 10, "dump on conditions indicates whether the SQL Server will create a shar\
ed memory dump file if any conditions configured using the sp_dumpconf\
ig stored procedure occurs. Possible values are 0 (not enabled) or 1 (\
enabled)."
go

exec sp_us_mesg 10619, 10, "number of large i/o buffers controls the number of extent size i/o dis\
k buffers which are allocated at server startup. These buffers are use\
d by 'disk mirroring', 'load database' and some dbcc commands."
go

exec sp_us_mesg 10645, 16, "Maximum dump conditions indicates the maximum number of shared memory \
dump conditions that can be configured on this server. The value of th\
is field may be from 10 to 100. The default value is 10."
go

exec sp_us_mesg 10816, 16, "The value of the 'dump on conditions' configuration parameter must be \
either 0 or 1."
go

exec sp_us_mesg 11013, 16, "Correlated columns are not allowed in the outer join clause of the sub\
query."
go

exec sp_us_mesg 11020, 16, "Pseudo-column SYB_IDENTITY is referenced from a stored procedure after\
 the identity column has changed. Please drop/recreate the stored proc\
edure."
go

exec sp_us_mesg 11710, 16, "Subqueries are not allowed in a DEFAULT clause."
go

exec sp_us_mesg 11728, 15, "SELECT INTO cannot be used in an INSERT statement to pull values from \
tables."
go

exec sp_us_mesg 12001, 16, "Unable to find entry for class: %d, attribute: %d, value: %d."
go

exec sp_us_mesg 12002, 16, NULL
go

exec sp_us_mesg 12003, 16, "Unable to allocate shared memory dump condition. All conditions (%d) a\
lready allocated."
go

exec sp_us_mesg 12004, 16, "Empty shared memory dump condition list head passed."
go

exec sp_us_mesg 12005, 16, "Cannot free shared memory dump condition. Entry 0x%x not found."
go

exec sp_us_mesg 12006, 16, "An entry already exists for class: %d, attribute: %d, value: %d."
go

exec sp_us_mesg 12007, 16, "Cannot set shared memory dump condition. An invalid attribute value wa\
s recevied: %d."
go

exec sp_us_mesg 12008, 16, "Directory name too long. The maximum directory length is %d characters\
."
go

exec sp_us_mesg 12009, 16, "File name too long. The maximum length is %d characters."
go

exec sp_us_mesg 12010, 16, "Unable to set shared memory dump condition. Invalid record type: %d."
go

exec sp_us_mesg 12011, 16, "Configuration of shared memory dump conditions is not available on thi\
s platform."
go

exec sp_us_mesg 12012, 16, "Unable to perform this operation. The internal dump condition table wa\
s not allocated at server startup time."
go

exec sp_us_mesg 12200, 10, "Current session (spid = %ld) is holding a lock belonging to a non-exis\
tent cursor. Please contact Sybase Technical Support."
go

exec sp_us_mesg 12803, 16, "CREATE VIEW failed because column %d in the view definition has a null\
 column name. Column names cannot be null."
go

exec sp_us_mesg 12900, 16, NULL
go

exec sp_us_mesg 13020, 10, "option"
go


/*
** ======================= GERMAN MESSAGE AREA ==============================
** ===========================================================================
** GERMAN MESSAGE AREA. USE "sp_oth_mesg" to add message
** exec sp_oth_mesg <error>,<message_with_no_linefeed>,<"german">
**
** SAMPLE GERMAN MESG
** MAKE SURE YOU ADD A "delete" line for each message added.
** exec sp_oth_mesg 9999,"delete","german"
** go
** exec sp_oth_mesg 9999,"German Testing message","german"
** go
*/

exec sp_oth_mesg 317, "delete","german"
go

exec sp_oth_mesg 420, "delete","german"
go

exec sp_oth_mesg 443, "delete","german"
go

exec sp_oth_mesg 539, "delete","german"
go

exec sp_oth_mesg 629, "delete","german"
go

exec sp_oth_mesg 644, "delete","german"
go

exec sp_oth_mesg 685, "delete","german"
go

exec sp_oth_mesg 691, "delete","german"
go

exec sp_oth_mesg 691, "delete","german"
go

exec sp_oth_mesg 692, "delete","german"
go

exec sp_oth_mesg 693, "delete","german"
go

exec sp_oth_mesg 694, "delete","german"
go

exec sp_oth_mesg 695, "delete","german"
go

exec sp_oth_mesg 696, "delete","german"
go

exec sp_oth_mesg 697, "delete","german"
go

exec sp_oth_mesg 698, "delete","german"
go

exec sp_oth_mesg 699, "delete","german"
go

exec sp_oth_mesg 835, "delete","german"
go

exec sp_oth_mesg 875, "delete","german"
go

exec sp_oth_mesg 876, "delete","german"
go

exec sp_oth_mesg 877, "delete","german"
go

exec sp_oth_mesg 945, "delete","german"
go

exec sp_oth_mesg 953, "delete","german"
go

exec sp_oth_mesg 1131, "delete","german"
go

exec sp_oth_mesg 1142, "delete","german"
go

exec sp_oth_mesg 1143, "delete","german"
go

exec sp_oth_mesg 1608, "delete","german"
go

exec sp_oth_mesg 1816, "delete","german"
go

exec sp_oth_mesg 1931, "delete","german"
go

exec sp_oth_mesg 1932, "delete","german"
go

exec sp_oth_mesg 2510, "delete","german"
go

exec sp_oth_mesg 2511, "delete","german"
go

exec sp_oth_mesg 2537, "delete","german"
go

exec sp_oth_mesg 2537, "delete","german"
go

exec sp_oth_mesg 2537, "delete","german"
go

exec sp_oth_mesg 2565, "delete","german"
go

exec sp_oth_mesg 2586, "delete","german"
go

exec sp_oth_mesg 2610, "delete","german"
go

exec sp_oth_mesg 2619, "delete","german"
go

exec sp_oth_mesg 3121, "delete","german"
go

exec sp_oth_mesg 3307, "delete","german"
go

exec sp_oth_mesg 3313, "delete","german"
go

exec sp_oth_mesg 3314, "delete","german"
go

exec sp_oth_mesg 3733, "delete","german"
go

exec sp_oth_mesg 3733, "delete","german"
go

exec sp_oth_mesg 3734, "delete","german"
go

exec sp_oth_mesg 3734, "delete","german"
go

exec sp_oth_mesg 3735, "delete","german"
go

exec sp_oth_mesg 3736, "delete","german"
go

exec sp_oth_mesg 3736, "delete","german"
go

exec sp_oth_mesg 3741, "delete","german"
go

exec sp_oth_mesg 4231, "delete","german"
go

exec sp_oth_mesg 4232, "delete","german"
go

exec sp_oth_mesg 4426, "delete","german"
go

exec sp_oth_mesg 4839, "delete","german"
go

exec sp_oth_mesg 4839, "delete","german"
go

exec sp_oth_mesg 5033, "delete","german"
go

exec sp_oth_mesg 7143, "delete","german"
go

exec sp_oth_mesg 7243, "delete","german"
go

exec sp_oth_mesg 7408, "delete","german"
go

exec sp_oth_mesg 7427, "delete","german"
go

exec sp_oth_mesg 7430, "delete","german"
go

exec sp_oth_mesg 7431, "delete","german"
go

exec sp_oth_mesg 7432, "delete","german"
go

exec sp_oth_mesg 7756, "delete","german"
go

exec sp_oth_mesg 7930, "delete","german"
go

exec sp_oth_mesg 7931, "delete","german"
go

exec sp_oth_mesg 8201, "delete","german"
go

exec sp_oth_mesg 8438, "delete","german"
go

exec sp_oth_mesg 9101, "delete","german"
go

exec sp_oth_mesg 9802, "delete","german"
go

exec sp_oth_mesg 9803, "delete","german"
go

exec sp_oth_mesg 9805, "delete","german"
go

exec sp_oth_mesg 9807, "delete","german"
go

exec sp_oth_mesg 9809, "delete","german"
go

exec sp_oth_mesg 9810, "delete","german"
go

exec sp_oth_mesg 9814, "delete","german"
go

exec sp_oth_mesg 9816, "delete","german"
go

exec sp_oth_mesg 9938, "delete","german"
go

exec sp_oth_mesg 9939, "delete","german"
go

exec sp_oth_mesg 10235, "delete","german"
go

exec sp_oth_mesg 10606, "delete","german"
go

exec sp_oth_mesg 10619, "delete","german"
go

exec sp_oth_mesg 10645, "delete","german"
go

exec sp_oth_mesg 10816, "delete","german"
go

exec sp_oth_mesg 11013, "delete","german"
go

exec sp_oth_mesg 11020, "delete","german"
go

exec sp_oth_mesg 11710, "delete","german"
go

exec sp_oth_mesg 11728, "delete","german"
go

exec sp_oth_mesg 12001, "delete","german"
go

exec sp_oth_mesg 12002, "delete","german"
go

exec sp_oth_mesg 12003, "delete","german"
go

exec sp_oth_mesg 12004, "delete","german"
go

exec sp_oth_mesg 12005, "delete","german"
go

exec sp_oth_mesg 12006, "delete","german"
go

exec sp_oth_mesg 12007, "delete","german"
go

exec sp_oth_mesg 12008, "delete","german"
go

exec sp_oth_mesg 12009, "delete","german"
go

exec sp_oth_mesg 12010, "delete","german"
go

exec sp_oth_mesg 12011, "delete","german"
go

exec sp_oth_mesg 12012, "delete","german"
go

exec sp_oth_mesg 12200, "delete","german"
go

exec sp_oth_mesg 12803, "delete","german"
go

exec sp_oth_mesg 12900, "delete","german"
go

exec sp_oth_mesg 13020, "delete","german"
go


/*
** ======================= FRENCH MESSAGE AREA ==============================
** ===========================================================================
** FRENCH MESSAGE AREA. USE "sp_oth_mesg" to add message
** exec sp_oth_mesg <error>,<message_with_no_linefeed>,<"french">
**
** SAMPLE FRENCH MESG
** exec sp_oth_mesg 9999,"French Testing message","french"
** exec sp_oth_mesg 9999,"delete","french"
** go
** exec sp_oth_mesg 9999,"french Testing message","french"
** go
*/

exec sp_oth_mesg 317, "delete","french"
go

exec sp_oth_mesg 420, "delete","french"
go

exec sp_oth_mesg 443, "delete","french"
go

exec sp_oth_mesg 539, "delete","french"
go

exec sp_oth_mesg 629, "delete","french"
go

exec sp_oth_mesg 644, "delete","french"
go

exec sp_oth_mesg 685, "delete","french"
go

exec sp_oth_mesg 691, "delete","french"
go

exec sp_oth_mesg 691, "delete","french"
go

exec sp_oth_mesg 692, "delete","french"
go

exec sp_oth_mesg 693, "delete","french"
go

exec sp_oth_mesg 694, "delete","french"
go

exec sp_oth_mesg 695, "delete","french"
go

exec sp_oth_mesg 696, "delete","french"
go

exec sp_oth_mesg 697, "delete","french"
go

exec sp_oth_mesg 698, "delete","french"
go

exec sp_oth_mesg 699, "delete","french"
go

exec sp_oth_mesg 835, "delete","french"
go

exec sp_oth_mesg 875, "delete","french"
go

exec sp_oth_mesg 876, "delete","french"
go

exec sp_oth_mesg 877, "delete","french"
go

exec sp_oth_mesg 945, "delete","french"
go

exec sp_oth_mesg 953, "delete","french"
go

exec sp_oth_mesg 1131, "delete","french"
go

exec sp_oth_mesg 1142, "delete","french"
go

exec sp_oth_mesg 1143, "delete","french"
go

exec sp_oth_mesg 1608, "delete","french"
go

exec sp_oth_mesg 1816, "delete","french"
go

exec sp_oth_mesg 1931, "delete","french"
go

exec sp_oth_mesg 1932, "delete","french"
go

exec sp_oth_mesg 2510, "delete","french"
go

exec sp_oth_mesg 2511, "delete","french"
go

exec sp_oth_mesg 2537, "delete","french"
go

exec sp_oth_mesg 2537, "delete","french"
go

exec sp_oth_mesg 2537, "delete","french"
go

exec sp_oth_mesg 2565, "delete","french"
go

exec sp_oth_mesg 2586, "delete","french"
go

exec sp_oth_mesg 2610, "delete","french"
go

exec sp_oth_mesg 2619, "delete","french"
go

exec sp_oth_mesg 3121, "delete","french"
go

exec sp_oth_mesg 3307, "delete","french"
go

exec sp_oth_mesg 3313, "delete","french"
go

exec sp_oth_mesg 3314, "delete","french"
go

exec sp_oth_mesg 3733, "delete","french"
go

exec sp_oth_mesg 3733, "delete","french"
go

exec sp_oth_mesg 3734, "delete","french"
go

exec sp_oth_mesg 3734, "delete","french"
go

exec sp_oth_mesg 3735, "delete","french"
go

exec sp_oth_mesg 3736, "delete","french"
go

exec sp_oth_mesg 3736, "delete","french"
go

exec sp_oth_mesg 3741, "delete","french"
go

exec sp_oth_mesg 4231, "delete","french"
go

exec sp_oth_mesg 4232, "delete","french"
go

exec sp_oth_mesg 4426, "delete","french"
go

exec sp_oth_mesg 4839, "delete","french"
go

exec sp_oth_mesg 4839, "delete","french"
go

exec sp_oth_mesg 5033, "delete","french"
go

exec sp_oth_mesg 7143, "delete","french"
go

exec sp_oth_mesg 7243, "delete","french"
go

exec sp_oth_mesg 7408, "delete","french"
go

exec sp_oth_mesg 7427, "delete","french"
go

exec sp_oth_mesg 7430, "delete","french"
go

exec sp_oth_mesg 7431, "delete","french"
go

exec sp_oth_mesg 7432, "delete","french"
go

exec sp_oth_mesg 7756, "delete","french"
go

exec sp_oth_mesg 7930, "delete","french"
go

exec sp_oth_mesg 7931, "delete","french"
go

exec sp_oth_mesg 8201, "delete","french"
go

exec sp_oth_mesg 8438, "delete","french"
go

exec sp_oth_mesg 9101, "delete","french"
go

exec sp_oth_mesg 9802, "delete","french"
go

exec sp_oth_mesg 9803, "delete","french"
go

exec sp_oth_mesg 9805, "delete","french"
go

exec sp_oth_mesg 9807, "delete","french"
go

exec sp_oth_mesg 9809, "delete","french"
go

exec sp_oth_mesg 9810, "delete","french"
go

exec sp_oth_mesg 9814, "delete","french"
go

exec sp_oth_mesg 9816, "delete","french"
go

exec sp_oth_mesg 9938, "delete","french"
go

exec sp_oth_mesg 9939, "delete","french"
go

exec sp_oth_mesg 10235, "delete","french"
go

exec sp_oth_mesg 10606, "delete","french"
go

exec sp_oth_mesg 10619, "delete","french"
go

exec sp_oth_mesg 10645, "delete","french"
go

exec sp_oth_mesg 10816, "delete","french"
go

exec sp_oth_mesg 11013, "delete","french"
go

exec sp_oth_mesg 11020, "delete","french"
go

exec sp_oth_mesg 11710, "delete","french"
go

exec sp_oth_mesg 11728, "delete","french"
go

exec sp_oth_mesg 12001, "delete","french"
go

exec sp_oth_mesg 12002, "delete","french"
go

exec sp_oth_mesg 12003, "delete","french"
go

exec sp_oth_mesg 12004, "delete","french"
go

exec sp_oth_mesg 12005, "delete","french"
go

exec sp_oth_mesg 12006, "delete","french"
go

exec sp_oth_mesg 12007, "delete","french"
go

exec sp_oth_mesg 12008, "delete","french"
go

exec sp_oth_mesg 12009, "delete","french"
go

exec sp_oth_mesg 12010, "delete","french"
go

exec sp_oth_mesg 12011, "delete","french"
go

exec sp_oth_mesg 12012, "delete","french"
go

exec sp_oth_mesg 12200, "delete","french"
go

exec sp_oth_mesg 12803, "delete","french"
go

exec sp_oth_mesg 12900, "delete","french"
go

exec sp_oth_mesg 13020, "delete","french"
go


/*
** ============================  DROP SPs ===================================
** ===========================================================================
** go
*/

drop procedure sp_us_mesg
go
drop procedure sp_oth_mesg
go
drop procedure sp_addlimsg
go
sp_configure 'allow update',0
go
reconfigure with override
go