Post reply

Changing Table Owner through GUI ?

  • September 5, 2006 at 10:10 am

    #114316

    In SQL 2000, one could change the owner of a table through Enterprise manager by going to: "Design Table" -> "Table & Index Properties".  This was handy for a developer with dbo rights, because the ownership defaults to their windows login, not dbo. They could easily change it to dbo. I don't see an equivalent GUI in SQL 2005. Is there one somewhere ?    It was simpler than having to use sp_changeobjectowner

     

  • September 6, 2006 at 1:28 pm

    #658867

    If you choose the Modify action in Management Studio for a table, show the Properties tab to find the Schema property.  You can pick a new schema from the list.

    Note that in SQL 2005, users and schemas are different animals.  You won't see user names in the dropdown list for Schema on a SQL 2005 server (unless there is a schema of the same name).

Viewing 2 posts - 1 through 1 (of 1 total)

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