怎样修改sp 的owner?

怎样修改sp 的owner?
---------------------------------------------------------------

use a system sp: sp_changeobjectowner

sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'

example:
EXEC sp_changeobjectowner 'authors', 'Corporate\GeorgeW'

if you are using 6.5, check out
http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14032

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus