Check out sp_change_users_login to recover "phantom" logins.
Works like a charm.
best, paul
At 02:47 PM 12/1/00 -0500, you wrote:
>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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
