> lookup sp_attach_db in BOL.
>
> It may not work if sp_detach_db was not used.
I've never had any problem getting sp_attach_db to work without previously
detaching the database. The problem I have run into is that logins from the
old server will still be stored in the attached database, and you can't
delete them from the SQL Enterprise Manager interface.
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
