You can try this (only works in SQL Server 6.5):
Backup your database first. Create a new database in the enterprise
manager. Right click on the database and select Transfer. In the
destination specify your suspect database. Click Start transfer.
Regards,
Dennis.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Dedy Darmayanto
Sent: Wednesday, 19 April 2000 14:26
To: Multiple recipients of list delphi
Subject: [DUG]: SQL server suspect
Hi all,
I am using Delphi 5 and Sql Server 6.5
My database is marking "suspect" by the system
does anybody know, how to get the data in this database
or to reset the suspect status
Thanks.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz