MS SQL Server - Re: no "properties" option on stored procedures (cant set permissions)

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: no "properties" option on stored procedures (cant set permissions)

Scott

2006-10-25, 6:00 am

thanks for reply.

i can see sp_changedbowner, it executes ok.

im not exactly sure what i should do with it now.

scott.

Tibor Karaszi

2006-10-25, 6:00 am

My guess is that the owner for the database (the SID) doesn't exist as a login in the master
database. Try setting the owner to sa, for instance.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"Scott" <http://www.sage-eshop.com> wrote in message
news:uF%233%23Hr9GHA
.4012@TK2MSFTNGP04.phx.gbl...
> thanks for reply.
>
> i can see sp_changedbowner, it executes ok.
>
> im not exactly sure what i should do with it now.
>
> scott.
>

Sponsored Links