I tried:

SELECT objspare from sysobjects where name = 'sysusermessages'
SELECT objspare from sybsystemprocs..sysobjects where name =
'sysusermessages'

which gives me:

1> SELECT objspare from sysobjects where name = 'sysusermessages'
2> go
objspare
-----------
65536

(1 row affected)
1> SELECT objspare from sybsystemprocs..sysobjects where name =
'sysusermessages'
2> go
objspare
-----------
0

(1 row affected)
1>





"Manish Negandhi" <negandhi.manish@gmail.com> wrote in message
news:78bb0bc9-0ba8-4d93-8e8b-f3224f746050@s50g2000hsb.googlegroups.com...
On Mar 28, 2:30 am, "Kjellemann" <kj...@kjellpettersen.com> wrote:
> I get an error when using sp_getmessage on a message that were put into
> sysusermessages with sp_addmessage.
> The sql is like this:
>
> create proc kpTest as
> declare @result varchar(255)
> exec sp_getmessage 30003, @result
> output
>
> The output:
>
> 1> kpTest
> 2> go
> Msg 11060, Level 16, State 1:
> Server 'PADDATEST', Procedure 'sp_getmessage', Line 100:
> This statement has exceeded the maximum number of recompilations (10).
> This
> indicates an internal error. Please note the error prior to this one and
> contact

This looks like CR323940. Check if following queries give u same
results .. if not post the results here

SELECT objspare from sysobjects where name = 'sysusermessages'
SELECT objspare from sybsystemprocs..sysobjects where name =
'sysusermessages'

-HTH
Manish Negandhi
[TeamSybase Intern]
sysobjects.objspare