SEO

#1 (**permalink**) 04-09-2008, 05:06 PM

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

#2 (**permalink**) 04-09-2008, 05:06 PM

You can try to update objspare for sysusermessages table to 0 and see
if that resolves your problem
It is a good idea to take backup your database before you execute the
update

here is how to do it..

user your_database
go
sp_configure 'allow update', 1
go

begin tran
update sysobjects
set objspare = 0
where name = 'sysusermessages'
go

--If 1 row affected: then commit otherwise rollback

-HTH
Manish Negandhi
[TeamSybase Intern]
> sysobjects.objspare- Hide quoted text -

#3 (**permalink**) 04-12-2008, 01:05 AM

Hei!

We tried this, and it worked !!

Thanks.

Kp

"Manish Negandhi" <negandhi.manish@gmail.com> wrote in message
news:2c532cdc-36b6-4cd2-902f-d6aa85dced56@a23g2000hsc.googlegroups.com...
> You can try to update objspare for sysusermessages table to 0 and see
> if that resolves your problem
> It is a good idea to take backup your database before you execute the
> update
>
> here is how to do it..
>
> user your_database
> go
> sp_configure 'allow update', 1
> go
>
> begin tran
> update sysobjects
> set objspare = 0
> where name = 'sysusermessages'
> go
>
> --If 1 row affected: then commit otherwise rollback
>
> -HTH
> Manish Negandhi
> [TeamSybase Intern]
>> sysobjects.objspare- Hide quoted text -

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: Error from sp_getmessage