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 NULL to other value

Hi,
Are there some functions in Transact-SQL which can change NULL to other
value , like change NULL to 0.SELECT COALESCE(x, 0) FROM (SELECT x = 1 UNION SELECT 4 UNION SELECT NULL) x
--
http://www.aspfaq.com/
(Reverse address to reply.)
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:Omk#8mlqEHA.536@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Are there some functions in Transact-SQL which can change NULL to other
> value , like change NULL to 0.
>|||Yes. Use ISNULL
"ad" wrote:
> Hi,
> Are there some functions in Transact-SQL which can change NULL to other
> value , like change NULL to 0.
>
>

Change NULL to other value

Hi,
Are there some functions in Transact-SQL which can change NULL to other
value , like change NULL to 0.
SELECT COALESCE(x, 0) FROM (SELECT x = 1 UNION SELECT 4 UNION SELECT NULL) x
http://www.aspfaq.com/
(Reverse address to reply.)
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:Omk#8mlqEHA.536@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Are there some functions in Transact-SQL which can change NULL to other
> value , like change NULL to 0.
>
|||Yes. Use ISNULL
"ad" wrote:

> Hi,
> Are there some functions in Transact-SQL which can change NULL to other
> value , like change NULL to 0.
>
>