Assigning dbo to objects without typing the "dbo."

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

galenboyerdev_at_hotpop.com
Date: 01/12/05 

Date: 12 Jan 2005 15:34:21 -0500

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: db_owner role in SQL 2k
    ... Try not to say "If sa is THE dbo", it's like saying "If I am the joe". ... might help to either say "If sa is the database owner" or, ... The login 'sa' could be listed in sysdatabases as the database ... FULL permission to do anything and everything. ...
    (microsoft.public.sqlserver.programming)
  • Re: Two DB Owners
    ... full permissions in all databases. ... Note that the user will still be known as the 'dbo' user as long as the ... I need to add the login 'BUILTIN\Administrators' ... > 'DYNGRP' and 'BFGROUP' roles of the Dynamics and DAVCatalog databases. ...
    (microsoft.public.sqlserver.security)
  • Re: How do I set the login name for a user?
    ... You are better to make a dbo roled account (database god?), although that is not my first recommendation for connections. ... name, key name, without login. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: dbcreator and restore?
    ... I also created a backup after the login was set to ... dbo and that is the backup that i successfully restored. ... >SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Who should I make the owner?
    ... Every login gets mapped to a username in every database they have access to. ... DBO is a special user name that exists in every database. ... NOT to think of DBO as meaning 'database owner' since many different logins ...
    (microsoft.public.sqlserver.server)