dbo Owner

Dear All,
How to setting certain user so when they create stored procedure, the
stored procedure belongs to dbo.
Thanks & Regards
Yap MichaelHi
Add the user to dbo_owner database role. If the user is a member of sysadmin
role so any objects he/she will be created with dbo. prefix. On the other
hand if the user is a member of dbo_owner database role asnd not a sysadmin
,so she/he will need to specify dbo with creation a object
User Alex
--
CREATE TABLE dbo.MyTable (col INT NO NULL)
--
CREATE TABLE MyTable (col INT NO NULL)
I will see Alex.MytTable ( because he does not specify the DBO user name)
"Yap Michael" <yapmichael2000@.gmail.com> wrote in message
news:%238pEs5%23SGHA.5924@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> How to setting certain user so when they create stored procedure, the
> stored procedure belongs to dbo.
> Thanks & Regards
> Yap Michael