Post reply

change db owner name without affecting the objects?

  • September 27, 2005 at 3:48 pm

    #91440

    our developer left the company and he has created numerous of objects such as the store procedures views, and triggers using his name as a dbo owner. I have found out the the objects that he owned but I need to know how to find out his db owner name in the script or objects. Is there a way to do it? Thanks.

  • September 27, 2005 at 4:08 pm

    #593494

    DBO is tied to a role in sql server.

    Do the objects say dbo.storedprocedurename?

    Or do they say username.storedprocedurename?

    if they say the user name, then they are not assigned to dbo.

    if it already says dbo. then there is nothing you should need to change. Except remove that users name from the database, and off the servers.

    Can you please provide examples of object names.

    Try sp_rename

    sp_rename

    Changes the name of a user-created object (for example, table, column, or user-defined data type) in the current database.

  • September 27, 2005 at 4:49 pm

    #593499

    for example it states dpeter.storeprocedurename instead of dbo.storeprocedurename. I also need to find out the dependency objects of the dpeter.storeprocedurename. Is there  way to find out?

  • September 28, 2005 at 1:24 am

    #593553

    Try sp_changeobjectowner

  • September 28, 2005 at 10:40 am

    #593751

    To find dependencies for the stored procedure, run this in Query Analyzer:

    sp_depends 'dpeter.storedprocedurename'

    Greg

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply