back, and sql server took care of them, however it wasn't a good feeling...
tony
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 12:34 PM
To: CF-Talk
Subject: RE: cfmx 6.1 (and mssql2k) server migration
> yeah, but you want to detach, then attach, since it will keep things
> concurrent...
I haven't needed to detach first if I just shut down the first SQL Server.
If I couldn't shut it down, I'd need to detach first. To the best of my
knowledge, all sp_detach_db does in addition to detaching the database is
update its statistics first, but it's not necessary to do that.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
