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 Repliesthis 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?
1.could any one tell me the difference between sp_dboption and sp_configure.
View 1 Replies View RelatedHi 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,
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 RelatedDoes an sp_dboption 'dbname','single user',true command execute succesfully when a background process is working on a database.
View 3 Replies View Related