<![CDATA[Latest posts for the topic "MSSQL改變Table Owner"]]> https://forum.andowson.com/posts/list/12.page JForum - http://www.jforum.net MSSQL改變Table Owner
這時我們需要先改變table的擁有人為dbo：
[code]exec sp_changeobjectowner 'oldowner.tablename', 'dbo'[/code]

然後再去刪除該帳號，再重新建立該帳號並將資料庫指派給該帳號當作db_owner即可。

參考資料：
http://blog.bestlong.idv.tw/2005/03/27/mssql-%E6%94%B9%E8%AE%8A-database-%E4%B8%AD-table-%E7%9A%84-owner/]]> https://forum.andowson.com/posts/preList/245/376.page https://forum.andowson.com/posts/preList/245/376.page GMT