Actually... as I recall there is a solution to that which I hacked together.
As I recall, there's a stored procedure to delete a user in the master database.
Just copy that sp across to the restored database, and run it on those users.
Worked for me. Neat, huh?
David Cummins
Dave Watts wrote:
>
> > 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
