Viewing 4 posts - 1 through 4 (of 4 total)
No IP changes, just need to change the domain and the service accounts.
July 8, 2004 at 10:24 am
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...
May 5, 2004 at 12:46 pm
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...
April 29, 2004 at 1:24 pm
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...
March 18, 2004 at 1:46 pm
Viewing 4 posts - 1 through 4 (of 4 total)