Please ignore my prior reply. I did not catch you were talking about
sp_attach_db. Sorry.
-----Original Message-----
From: Rich Pransky [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 9:10 PM
To: CF-Talk
Subject: RE: SQL 7 database transfer from one server to another
Don't you have an option whether or not to transfer individual objects such
as logins?
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 11:48 AM
To: CF-Talk
Subject: RE: SQL 7 database transfer from one server to another
> Look up the syntax for sp_dettach and sp_attach.
> With that you can move the db by hand with no leftovers.
There's one problem that I ran into with moving databases with sp_attach_db
on SQL Server 7. If you've specified any logins for that database within the
original database server, the database will still have those logins when you
attach it to the new server. You won't be able to delete the logins, either;
they'll be "phantom" logins.
If you can, you're better off moving a database by backing up from the
original server, then restoring into a new database on the new server.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
