how to connect to server 2000 as a single user mode

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lester Policarpio SSCertifiable Points: 7109 More actions · Answer 1

This is the code snippet I saved. it works on sql 7 (I think should also work with sql 2000). Try it first in your test server

USE master --use master db

GO

EXEC sp_dboption dbSVS, 'Single User', True --set db to single user

EXEC sp_renamedb 'dbSVS', 'dmdbsvs' --change db_name

EXEC sp_dboption dmdbsvs, 'Single User', False --change back db to multiple user

GO

"-=Still Learning=-"

Lester Policarpio

U J SSCrazy Points: 2423 More actions · Answer 2

This may give more clear picture =>

Cookies on SQLServerCentral