Welcome Guest, you are in: Login

MUST Creative Engineering Laboratory

RSS RSS

Navigation



Technical Doc



Search the wiki
»

MUST Corp.

MUST Corp.

www.must.or.kr

 Microsoft CERTIFIED Partner Software Development, Web Development, Data Platform

 Microsoft Small Business Specialist

MCSD

Microsoft Certified IT Professional

Microsoft Certified Professional Developer

mssql 2008 테이블 소유자 변경

RSS
Modified on 2014/03/15 13:37 by Administrator Categorized as Uncategorized
alter schema 변경해야할소유자 transfer 소유자.테이블명
예)alter schema dbo transfer test.abc abc 테이블의 소유자를 test에서 dbo로 변경

특정 DB의 모든 테이블 소유자 dbo로 변경

use "테이블명"
exec sp_MSforeachtable 'sp_changeobjectowner ''?'' , ''dbo'''
예제) test DB 모든 테이블 dbo로 변경

use "test"
exec sp_MSforeachtable 'sp_changeobjectowner ''?'' , ''dbo'''

MUST Creative Engineering Laboratory

ImageImage Image Image

Image Image Image Image Image Image Image

Copyright © 2010 MUST Corp. All rights reserved. must@must.or.kr
This Program is released under the GNU General Public License v2. View the GNU General Public License v2 or visit the GNU website.