Hi Derek, Veteren, and all of you out there,

Many thanks to all of you. I managed to restore the db with all logins.

Hi Derek,

Thanks for enlighting me on how to go about when db is in suspect mode. Would rather appreciate if you can show me how to resync the logins.

Thanks a...

Hi all,

I am using SQLAgent mail with Outlook 2000. Configure Outlook to use internal exchange server for sending mails by setting up Operator(s).

If Outlook 2000 is out of your budget,...

Hi all,

How about select count(*) for the row(s) that created on that date, after that date or before that date?

thanks in advance!

Hi everyone out there,

Thanks for the comments. Now, I get the clearer idea.

Suppose I chose to drop, recreate the db, and then restore from the backup. How about the logins?...

Hi everyone out there,

Many thanks for you guys' suggestion.

Now this DB is "disappearing" at all. No way to recover.

Now,  I want to restore this db from the latest backup tape...

May be you can try to explicitly grants NT\Authority system - sysadmin rights?