This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Command to detach database during uninstallation
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Aug 10, 2011
09:47 AM
Command to detach database during uninstallation
Please tell the command which i can use in VBscript to detach the database, attached to SQL Server 2005 Enterprise. I have installed the SQL with default instance.
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Aug 11, 2011
01:57 PM
As an alternative, you can use this to detach database in a .bat file.
SQLCMD -b -E -S "ServerName" -Q "sp_detach_db 'DatabaseName'"
Do SQLCMD /? from a CMD prompt for help.
SQLCMD -b -E -S "ServerName" -Q "sp_detach_db 'DatabaseName'"
Do SQLCMD /? from a CMD prompt for help.