did you move the Logins as well and which method did you use.?

Try this goto the Database (use Database)

then sp_change_users_login 'Report'

if anything shows up in the RESULTS, they are Orphaned...

Are you using a windows ID or SQL ID in OSQL -U and just a note, try using SQLCMd insted of OSQL as it will be removed in future versions.

Also,...

I think you can only use SQL Logins with the -U and -P Switch.

In order to mask your PAssword you can specify OSQL -U username then press enter and in...

By the way: Which EDITION/version of SQL are you using

Are you backing up to the default Location or Other Location than \MSSQL\Backups Folder.

If you have different location, Pl check...

Check to see if this relates to your issue:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=309672&SiteID=1

also they talk about AUTO CLOSE Peoperty on those Databases. Check that

which version/Edition of SQL Server are you using.

Are you by any chance using SQL Express.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80355

ALTER DATABASE (DBNAME)

MODIFY FILE (NAME='LOGICAL FILE NAME', FILENAME ='NEW FILE PATH')

Forgot to mention, After running the above Query, all the GRANT Statements will be in the result window. Just copy and past to another window and execute, you should be...

TRY THIS:

use dbname

select 'GRANT EXECUTE ON '+name+ ' to username' from sysobjects

where type='P'

and category=0

do you get the same error when connected using SA

Which OS are you using? Which SQL Server edition/version

yes DTS or SSIS is a good approach and secure.

SSIS supports 2000 Databases.

use the Transfer SQL Server Objects Task in SSIS.

also use a VBScript or a T-SQL

http://www.sqlservercentral.com/Forums/Topic451801-8-1.aspx

I am not sure, how to do a BULK Load.

Only if you have all you packages under one Project.

Or you can create a batch File with the DTUTIL.

Have you checked...