Chage database Master (Single User Mode)

[Guest_imported]

Hello, I have a copy of database master and I want to copy this db in another server. Doing this I need to run SQLServer in single user mode ( using parameter -m) but when I do this I don't know how to continue...

THANKS.

 

[Gundapaneni]

Hi,
It may helps to you try this,

exec sp_dboption 'databasename','single user','TRUE'

Madhu.