Re: Assigning dbo to objects without typing the "dbo."

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 01/12/05


Date: Wed, 12 Jan 2005 15:37:17 -0500

Is the Windows account in the db_owner role?

What is the owner showing up as?

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
<galenboyerdev@hotpop.com> wrote in message news:u8y6ybd4i.fsf@hotpop.com...
> Is there anyway to login with SQLServer authentication and issue the
following ddl statement:
>
> create table some_table (id integer)
> go
>
> and have it owned by dbo, (that is without having typed "dbo.")
>
> Thanks.
>
> -- 
> Galen Boyer


Relevant Pages

  • Re: who wants a crack at this
    ... > should be able to reverse engineer it easily. ... > return hash; ... This is probably an early version of the login 4.2 script. ... which are possible last letters in the password. ...
    (sci.crypt)
  • Re: Server Registration fails - figure this out !
    ... looking at the registry setting doesn't mean it is actually ... Query Analyzer or osql - with sa or login as the domain user ... >> Make sure the windows account being used has a login, ... >> any other group membership. ...
    (microsoft.public.sqlserver.security)
  • Re: OT: Teusday Titilation
    ... logs I'd get an call. ... Change your IP address, login as some cluser, visit said link, and ... reverse the process. ...
    (microsoft.public.cert.exam.mcse)
  • Re: FTP authentication group?
    ... If it's a windows account, then it will be able to login remotely. ... READ and etc permission on the ftp path. ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: OT: Teusday Titilation
    ... Change your IP address, login as some cluser, visit said link, and reverse ... Mo easy dan dat, I jes remote into home box and lookit from dere. ...
    (microsoft.public.cert.exam.mcse)