You said it better than I tried to!

Andy

Just disregard the log file - move it to another folder. Then try again. All transactions are completed before the db can be attached, so the log is not important.

Andy

...

I doubt transaction log is affecting it any. The best way to rebuild your indexes is to create a maint plan (dont bother with the backup tab) that rebuilds the...

It should work with no problem, it will auto upgrade the db to SQL2K compatible at the time its attached. I'd suggest first checking to make sure the db doesn't...

Probably a cursor is easiest, just open it with a select that gives you the table names that match. You could also use sp_msforeachtable. I'd proceed cautiously!

Andy

Ana, as long as you're trying to solve your problems/putting forth some effort, we'll do what we can to help. That's what we do!

I'll try to look at the stats...

How are you doing the update? ADO? Stored Proc? T-SQL?

Andy

DTC not running? Just a guess!

Andy

Another note on truncate from BOL (SQL2K):

"TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and...

Have you compared IO and CPU usage between your solution and the top using solution? I would expect (but never know) that using Top would be faster since it doesn't...

sp_msforeachdb 'use ?;select db_name() as DBName, count(*) as ObjectCount from sysobjects'

Andy

ADO has built in paging as well.

Andy

I'll have to look. I know for sure you can set the application name in an ADO connect string, but I don't remember seeing anything for the host. On the...

I know that a while back SQL Mag had a script to dump jobs including multiple schedules. Maybe worth looking for, for ideas anyway.

Andy

I think you're on the right track, if anything raises a dialog in SQL Agent (or xp_cmdshell) you're done. Super good error handling helps. My preferred solution (I know not...