I have had mixed success migrating the packages. I guess I'm just trying to confirm that even with a successfully migrated package, it will not execute after 2008?

I cannot see the packages under the Legacy node. I'm pretty sure we installed all the backward compatibility necessary.

The packages do run. I'm just concerned that I don't seem...

I used the Migration Wizard, so they now exist in MSDB on the 2008 server. If I create a new SSIS package, navigate to Project menu option and select Add...

I have successfully "practiced" this migration to 2000 5 or 6 times now. But only yesterday noticed that the "practice" 2k server displays NULL, while our production 7 server displays...

Sorry, that wasn't clear. We are first moving to 2k then 2008. I'm seeing the NULL dbname when running sp_who2 in SQL 2000.

Thanks. I did look in sysobjects, but there is no 99. Don't know if it is a system table or what.

Think I'll try to alter the data file first. If...

Maintenance log states the following....

[1] Database Image: Check Data and Index Linkage...

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8998: [Microsoft][ODBC SQL Server Driver][SQL Server]Page corruptions on the GAM, SGAM, or PFS...

I have since checked for orphaned users (sp_change_users_login)  - no orphans.

The owner of Database_A which contains the table referenced in the permission denied message is SA.

The database which contains...

I caught my terminology mixup this morning when I checked my post. Sorry, it was a rough day. As you said, I meant Full, Diff and transaction log. My understanding is that...

Good suggestion. Thanks.

Thanks to all. That's what I needed.

We checked and never more that 50 or so spids at any given time.

That did it. Thanks much.

I guess I can execute in a DTS package?

Thanks for the help.

Thanks for the info. There are no locks. This has happened a time or two in the past, and as everyone suggests, the only way we've been able to remove...