SQL Question

You have to turn on Single User mode on the database itself; you can't issue a connection command that forces the database into single user.
Open Enterprise Manager, drill down to your SQL server, expand the Databases until the one you want is visible, right-click -> Properties -> Options tab.
Under the Access section, select the Restrict Access checkbox, then below that select Single User Mode.
Click OK.

That's it.

Make sure no one is connected to the DB before you do this, though!

Now connect to the SQL server before anyone else does.

hope this helps

In order to start an instance of Microsoft? SQL Server? in single-user mode using the startup option -m. This will bring up the entire server in single user mode, no one else will be able to access it while you are connected to it. You may also wantto change the port number to something only you know for the time being.

This question was closed by the author