SQL Server Gems

Thursday, April 27, 2006

SQL Server Express Utility (SSEUtil)

Check out this gem - SQL Server Express Utility (SSEUtil)

"
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.

"
Src: (http://go.microsoft.com/fwlink/?LinkId=44178)

0 Comments:

Post a Comment

<< Home