Re: User names

From: Laura K (klkazanAT_at_ATcharter.net)
Date: 12/24/04 

Date: Thu, 23 Dec 2004 21:39:46 -0800

Well learned something really important today I thought I would pass on.

The issue was resolved by installing SP3 for SQL server.

Now no matter where I create the tables, now that I have installed the SP,
the owner is dbo and not username. Apparently I was doing everything right
(except keeping track of updates).

Laura K

"Laura K" <klkazanAT@ATcharter.net> wrote in message
news:eWsxhjT6EHA.3504@TK2MSFTNGP12.phx.gbl...
>I am using a remotely hosted SQL for a website. The host company has given
>me three user names and passwords. When I create tables either in the EM
>or by using Access and upsizing the tables are owned by the user name. I
>need them to be owned by dbo. What am I doing wrong?
>
>
>
>

Relevant Pages

  • Re: DBO Best Practices
    ... lines of always owner qualifying objects... ... someone who are just "a" dbo. ... > doesn't explicitly reference the object's owner (because SQL Server will ... The startup account defines the ...
    (microsoft.public.sqlserver.security)
  • Re: DBO Best Practices
    ... If you let DBO own databases or objects then regular ... Please note that the DBO user is identified by the SQL Server process ... the SQL Server startup account (for the ... SQL Server process) controls SQL Server's ability to work with NT's objects ...
    (microsoft.public.sqlserver.security)
  • Re: ASP.net insists on using dbo. to call aspnet_* stored procedures
    ... No. mysql_login is one account and the dbo is another account, ... SQL Server 2000 developer in same machine. ... connection string is setup to use the sql login assigned to the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASP.net insists on using dbo. to call aspnet_* stored procedures
    ... dbo is the schema used in SQL Server and, even if removed from queries, is technically still there. ... It sounds more like a permissions error or connectivity problem than a dbo problem. ... Is SQL Server on the same box as your application? ... the remote server once again, but I still get errors like this: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: dbo qualified name error w Access 2003
    ... correctly, things ended up being owned by dbo, which is *not* ... One tool you should use is SQL Profiler. ... to see the calls between Access and SQL Server, ... >When I use an adp from Access 2000, this code executes successfully for all ...
    (microsoft.public.sqlserver.msde)