Posted by Erland Sommarskog on 10/02/62 11:44

(andyblum@gmail.com) writes:
> When we goto that line I see:
>
>
> EXEC %%ErrorMessage(ID = @msgnum).Lock(Exclusive = 1)
>
>
> What is the "%%" doing - Does this make it impossible to modify?

That is some special syntax that works only in system procedures, which
is not availble to us user. Or perhaps it is, given the right settings
and environments. But it would be entirely unsupported to use it.

Furthermore, system procedures no longer live in the master database,
but in the hidde nmssqlsystemresource database. That database is
intended to be readonly. When Microsoft ships a service pack of a hotfix
with changes in system procedures, they just replace the resource database,
so if you were able to make changes system procedures, you would lose
them with a service pack.

It looks as if you will have to change your routines, so that in the
future, only sysadmin users can add messages.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]