Hi there,

I have limited experience, but I do know one thing that might help. SQL 2000 did not have schemas, but rather owners, so a fully qualified table name would be something like database.owner.tablename, wheras with SQL Server 2005, they introduced schemas, so now a fully qualified table name would be something like database.schema.tablename.

Owners in SQL Server 2000 corresponded to user names. Schemas in SQL Server 2005 and up correspond to LISTS of user names. Maybe what you need to do is make sure that you have users in your new database with the same names as the "owners" of the tables, and then grant those users rights to the new schema. Either that, or create schemas in your new database with the same name as users in your old database. Maybe that'll at least get you started. My gut feeling is that the fully qualified table name is getting messed up the T-SQL. What used to be database.owner.tablename is now database.schema.tablename, and schema != owner. Maybe you can trick it by creating schemas with the same name as the old owners.