SSEUtil RTM version is now available (by yag)

For all you developers who love the command line, or want an easy way to perform simple administration functions on SQL Server 2005, you can now download the SQL Server Express Utility. Among its capabilities, you can:

  • Connect to the main instance or user-instance of SQL Server.

  • Create/Attach/Detach/List databases on the server.

  • Upgrade database files to match the version of the server.

  • Execute SQL statements via the console (similar to SQLCMD) or the console window (UI).

  • List the instances of SQL Server on the local machine or on remote machines.

  • Log all input/output.

and more! One hint – it works with more than just SQL Express. It will work with SQL Server 2000 and SQL Server 2005 as well.

Comments (2)

  1. SSEUtil.exe isn’t working as advertised for me with a default SQLS 2005 instance and SQLEXPRESS named instance on a test partition, logged on to Windows Server 2003 as Administrator. SharedMemory, TCP/IP and Named Pipes are enabled for both instances and the clinet.

    SSEUtil -listsrv returns

    OAKLEAF-MS15SQLEXPRESS (Network Service)

    OAKLEAF-MS15 (Local System)

    I have AdventureWorks (OLAP) and Northwind installed on botht the default and SQLEXPRESS (both instances behave normally with SSMS).

    SSEUtil -l [.SQLEXRESS] returns

    1. master

    2. tempdb

    3. model

    4. msdb

    AdventureWorks and Northwind are missing from the list. Does the -l switch support only attached databases?

    SSEUtil -s {OAKLEAF-MS15 | .} -l returns a

    "The user instance login flag is not supported on this version of SQL Server." or "A connection was successfully established with the server but an error occured during the login process (… shared memory provider … No process is on the other end of the pipe.)

    Thanks in advance,


  2. Antoine Cote [MS] says:

    Hello Roger,

    I guess the reason you’re not seeing your databases listed is that SSE supports two types of instances: (1) Main instance and (2) Per-user instance. By default, SSEUtil works against the user instance. If you want to work against the main instance, you need to use the -m switch. For example: SSEUtil.exe -l -m



    Visual Studio .NET team.