if you are using 3rd party backup software like for e.g. Tivoli it truncates TRN LOGs

FROM BOL

Each table that has at least one text, ntext, or image column also has a row in sysindexes with indid = 255.

The column FirstIAM points to the...

not sure if you have taken Tail log backup & restore with Recovery.

Run this for that Database & see what the results it shows

EXEC sp_change_users_login 'Report'

Thanks

Try to run this command from \Binn folder

Thx

I am aware of this feature & moment i check that OFF it prompts another window about entering user credentials. but this one is risky & i don't want to...

You can create SQL TASK with SMPT MAIL that can send emails with reports ZIPPED.

http://www.sqldev.net/xp/xpsmtp.htm

I hope this helps

Follow this link, it will answer some of your questions

http://www.sqlservercentral.com/columnists/jDave/2963.asp

I hope this helps. Thx

Create DDL triggers on the table which host serial numbers also look into SQL 2000 BOL for "finding specific events in" under  traces. also look into sp_trace_xxxxx that will...

I hope this may help         

http://www.mssqltips.com/tip.asp?tip=1208

Suspect SQL Server 2000 Database

to attach system databases this link might be helpful. http://support.microsoft.com/kb/224071/

.MDF as nothing do with .LDF as there are no data pages in LDF & .LDF is log files with LSN. when you try to attach DB see the physical...

look into SQL Server 2000 BOL triggers, creating

based on error message it seems to me that you are trying to enter data in the column that doesn't accept NULL. in tempdb.dbo.#spdbdesc

No. you might have to call Microsoft PSS.