View Single Post

   
  #3 (permalink)  
Old 04-12-2008, 01:05 AM
Kjellemann
 
Posts: n/a
Default Re: Error from sp_getmessage

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 -



Reply With Quote