changeobjectowner permission

Hi
Is it possible that an user database (without server functions) own permissi
on on sp_changeobjectowner?Antonio,
The BOL says the following: Only members of sysadmin fixed server role, the
db_owner fixed database role, or a member of both the db_ddladmin and
db_securityadmin fixed database roles can execute sp_changeobjectowner.
As far as I know, this is correct. Are you having an experience that
suggests otherwise?
Russell Fields
"Antonio" <anonymous@.discussions.microsoft.com> wrote in message
news:C79A1502-34D7-4665-8BBE-489170481915@.microsoft.com...
> Hi
> Is it possible that an user database (without server functions) own
permission on sp_changeobjectowner?
>

changeobjectowner permission

Hi
Is it possible that an user database (without server functions) own permission on sp_changeobjectowner?
Antonio,
The BOL says the following: Only members of sysadmin fixed server role, the
db_owner fixed database role, or a member of both the db_ddladmin and
db_securityadmin fixed database roles can execute sp_changeobjectowner.
As far as I know, this is correct. Are you having an experience that
suggests otherwise?
Russell Fields
"Antonio" <anonymous@.discussions.microsoft.com> wrote in message
news:C79A1502-34D7-4665-8BBE-489170481915@.microsoft.com...
> Hi
> Is it possible that an user database (without server functions) own
permission on sp_changeobjectowner?
>

change sa password for sql agent

Hi!
Is it posible to use sql to change sa password for sql
agent
Check the sp_password system stored proceedure. That could help.
"kimi" <anonymous@.discussions.microsoft.com> wrote in message
news:0a2e01c52e9a$f10539e0$a501280a@.phx.gbl...
> Hi!
> Is it posible to use sql to change sa password for sql
> agent

change sa password for sql agent

Hi!
Is it posible to use sql to change sa password for sql
agentCheck the sp_password system stored proceedure. That could help.
"kimi" <anonymous@.discussions.microsoft.com> wrote in message
news:0a2e01c52e9a$f10539e0$a501280a@.phx.gbl...
> Hi!
> Is it posible to use sql to change sa password for sql
> agent