how to change Owner

From: Mustafa (Mustafa_at_discussions.microsoft.com)
Date: 03/31/05

  • Next message: Roji. P. Thomas: "Re: how to change Owner" 
    Date: Thu, 31 Mar 2005 00:51:02 -0800

    i want to change the database owner to dbo.rightnow the owner is

    test.i want to replace this owner with dbo.

    i execute the sp_changeobjectowner 'tbluser' ,'dbo'

    while i try to this i got the error

    Server: Msg 15001, Level 16, State 1, Procedure

    sp_changeobjectowner, Line 38
    Object 'tblUser' does not exist or is not a valid object for this

    operation.

    i login as an 'sa' while trying to perform this operation.

    Please let me know how do i change the owner.

  • Next message: Roji. P. Thomas: "Re: how to change Owner"

    Relevant Pages

    • Re: ADP: Cant use stored procedure on remote SQL server
      ... Not only I use dbo everywhere but I ... If you don't mention the owner when creating a new stored procedure, view, ... BTW in the database window, all the stored procedures are followed by ... Check also the owner of the SPInc stored procedure. ...
      (microsoft.public.access.adp.sqlserver)
    • Re: rda push when owner is not dbo.
      ... If I launch the sql query analyzewr and try to run the ... I'm pretty configdent that the owner name not being qualified is the ... > I pull the table with rda to a local table named task. ... > I also created a test table in the same database with owner dbo and I ...
      (microsoft.public.sqlserver.ce)
    • Re: Question about dropping owners permissions...
      ... When a member of the db_owner role creates an object, ... dbo, must the owner must be specified: ... >>> create databases themselves. ... Can anyone help me reach my end goal: Allowing developers to ...
      (microsoft.public.sqlserver.security)
    • Re: User names
      ... I don't have a pre-sp3 server to try this on, but in sp3, if you are a user ... byjust specifically giving the owner name in QA. ... > dbo was the owner. ...
      (microsoft.public.sqlserver.server)
    • Re: not creating tables as dbo anymore ?
      ... Database Owner (dbo) ... existing user ID in the database specified by database_name. ... with the login of the current connection. ...
      (microsoft.public.sqlserver.security)