Board index MS SQL Server

The database MSDB is marked suspect on SQL SERVER 6.5

The database MSDB is marked suspect on SQL SERVER 6.5

Post by Tibor Karasz » Tue, 14 Nov 2000 16:31:43



Eric,

Are you absolutely sure that the KB applies to your situation? A database can be
marked suspect for many reasons....

I guess that you are looking for sp_resetstatus? I believe that the source is on Books
Online, but you might want to check out TechNet if there's some fix available.

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.
FAQ at: http://www.sqlserverfaq.com


The question is serious!
The technical card Q193453 indicates to me that the stored procedure Instsupl.sql
should solve my problem.
Unfortunately, I do not find this procedure in my distribution of SQL Server.
I in taken to you, could you send a copy of this file to me.
With my thanks, Eric.

 
 
 
Top

1. The database MSDB is marked suspect on SQL SERVER 6.5

Usually when it does that it includes the source for the stored proc and you
have to create it yourself. Look some more in Books Online.
Sorry i don't have SS6.5 BOL loaded anymore. In 7.0 it's in the BOL but
probably different.


The question is serious!
The technical card Q193453 indicates to me that the stored procedure
Instsupl.sql
should solve my problem.
Unfortunately, I do not find this procedure in my distribution of SQL
Server.
I in taken to you, could you send a copy of this file to me.
With my thanks, Eric.

2. Saludos desde México...

3. SQL 6.5 MSDB marked 'suspect'

4. Active Directory and SQL

5. SMS Version 2.0 Database under MS SQL 6.5 Marked Suspect

6. mail merge automation in VBA

7. MSDB gets marked suspect

8. Upgrading from 7.3.3 -> 7.3.4

9. msdb marked as suspect

10. msdb marked "suspect"

11. SQL Server 2000( SP3) : Error 3314, 9001 and database gets marked Suspect

12. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

13. sql database marked suspect


All times are UTC
Board index