Sp_dboption??

Apr 20, 2001

this is the message i get when i use 'sp_renamedb....."

A member of the sysadmin role must set database 'distributors' to single user mode with sp_dboption before it can be renamed.

what do i need to do set database to single user mode (i believe that that is what i'm need to do now?

View 3 Replies


ADVERTISEMENT

Sp_dboption

Jul 25, 2005

I noticed that BOL says that the above is possibly going away.  What's the official way to print out all your db options once it goes away, i.e. what are we supposed to do to quickly look at dboptions with doing sp_dboption 'databasename'?

View 6 Replies View Related

Sp_dboption And Sp_configure

Apr 14, 2008

1.could any one tell me the difference between sp_dboption and sp_configure.

View 1 Replies View Related

Sp_dboption Parameter

Feb 28, 2008

Hi there,

I'm trying to remember which parameter i used for sp_dboption to fix the "data access" problem when I tried to synchronize one server to another.

I can't remember the exact error msg but it was something like "data access is not permitted" or "data access denied" or something like that.

does anyone know what error msg I am talking about? and how to fix it using sp_dboption??
I'd very appreciate it if someone can give me the exact error msg as well!


thanks,

View 2 Replies View Related

Follow Up To Exec..master And Sp_dboption

Jul 20, 2005

Hi allI had some info on setting db owners and chaining so I can execute a dtsrun(many thanks to Dan for that)I have taken the comments on board and done some more research on theinternet, but I'm still struggling.I am testing this on my personal edition, but when I runEXEC sp_dboption 'my dbname', 'db chaining', trueit tells me that the SP doesn't accept the option db chaining.I ran select @@version and I have SP3 on where I believe this option wasimplentedcan anyone give me any further pointers.many thanks for any helpAndy

View 2 Replies View Related

Does A Background Process Block Sp_dboption Command

Jan 25, 2008

Does an sp_dboption 'dbname','single user',true command execute succesfully when a background process is working on a database.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved