Re: Error from sp_getmessage

Hei!

We tried this, and it worked !!

Thanks.

Kp


"Manish Negandhi" <negandhi.manish@xxxxxxxxx> wrote in message
news:2c532cdc-36b6-4cd2-902f-d6aa85dced56@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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 -


.

Relevant Pages

  • Re: Backup/Restore question
    ... > I pass the backup statement. ... >> No need to create a "blank database" first. ... >> when you execute the RESTORE command. ... >> execute your restore command from there. ...
    (microsoft.public.sqlserver.programming)
  • Re: Daily Backup Filename
    ... Execute the below procedure inMaster database and schedule it using ... procedure will backup all the databases except ... DECLARE @DBNAME VARCHAR ...
    (microsoft.public.sqlserver.programming)
  • Re: Making security backups with ado
    ... I suppose you're right that's the best solution, but I wanted to store the ... > The best solution seems to use backup database instead ... You should create new database and copy ... Most DBMS will let you execute SELECT .. ...
    (borland.public.delphi.database.ado)
  • Re: Backing up SQL Server
    ... simply execute the backup database commands in SQL, ... SQL Server MVP ... Pro SQL Server 2000 Database Design - ...
    (microsoft.public.sqlserver.programming)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)