Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-08 : 07:17:47
|
| Alan writes "Is it possible to create scripts which can be started remotely to attach and detach databases into SQLExpress 2005.If so how." |
|
|
Lance Delano
Starting Member
2 Posts |
Posted - 2005-09-12 : 19:58:44
|
| Attaching and Detaching are pretty straight forward TSQL commands. You can use SSEUtil (available on the web) to do it pretty easily from a command file. You should be careful of whether you want this to run in a admin or a non-admin scenario on the target box. SSE enables the automatic attach and detach of MDFs if you are using the attach style connection string. In particular with the User-Instance = true. |
 |
|
|
|
|
|
Attach/Detach on SqlExpress 2005