Question about attaching database

If I use the attach database tool will it automatically kill any connections to my database from my website, or will I need to do some other action to get these connections closed?

 

Hi,
The Attach tool is awesome but you need to use it with care.
It should only be used with a blank DB.
Then once you Attach you should make any changes or additions. (i.e. Merge)
Keep in mind if you don't have a local SQL Server you can download and use SQL Server 2008 Express for free to merge you individual DBes.
I did a simple Webcast for that part already and it is on: http://www.dasptv.com/
All the best,
Mark

 

Why?

I'm going to be taking a backup of my production database make some changes to it with a local instance of SQL Server (stuff that I can't do while it is online), detach the database file, upload it to my web site and then attach it to the discountasp server.

Standard stuff with SQL Server.

I still would like to know if the attach tool will kill any existing connections.

 

...Yes it will work that way too.
I've used the Attach feature here from one server to another, same DB version.
Everything was kept alive while I did it.
You should only have your site off-line for a few minutes doing it that way.
All the best,
Mark

 

Thanks, everyone, for your answers.