No IP changes,  just need to change the domain and the service accounts.

The most effective method we found was based on the database size.  For smaller databases we did a detach, copy files to new server, and attach.  For larger databases (>5GB...

Here's some code that will build the code to resynch the users after you restore.  Just run it from the restored database.

select 'exec sp_change_users_login @action=''update_one'',@loginname=''' +

 name + ''',@usernamepattern=''' + name...

Found the problem was due to the sybase client being loaded.  The query was using that copy of bcp.  Fixed the problem by having the developer putting an explicit path.

Thanks...