Quick and Easy way to mass detached all user databases in Microsoft SQL | Nevermore.us

So, i was cleaning up my “test server” and wanted to detach all the databases i had currently attached in MS SQL. Assuming you installed everything to their default locations this is all you should need to do in order to mass detach all the user db’s.

Como hacer detach de una base de datos sql. Aun cuando en el ejemplo se hace para todas las bases se puede hacer para una unica base de datos

more :
Quick and Easy way to mass detached all user databases in Microsoft SQL | Nevermore.us

more about SSEUTILS.exe by microsoft (esto fue sacado de la pagina de microsoft)

Overview

SSEUtil.exe is a tool that lets you easily interact with SQL Server. Among other things, it allows you to:
• Connect to the main instance or user-instance of SQL Server.
• Create, attach, detach, and list databases on the server.
• Upgrade database files to match the version of the server.
• Execute SQL statements via the console (similar to SQLCMD).
• Retrieve the version of SQL Server running.
• Enable and disable trace flags (for example, to trace SQL statements sent to the server by any client application)
• List the instances of SQL Server on the local machine or on remote machines.
• Checkpoint and shrink a database
• Measure the performance of executing specific queries.
• Create and playback lists of SQL commands for the server to execute.
• Log all input and output.

link to download (para descargar):
http://www.microsoft.com/downloads/details.aspx?FamilyID=fa87e828-173f-472e-a85c-27ed01cf6b02&displaylang=en


traducciones: yomismo