\ub85c\uceec\uc11c\ubc84\uc5d0 backup\ubc1b\uc558\ub358 .bak\ud30c\uc77c\ub85c..
\n\ub2e4\ub978 \uc11c\ubc84\uc5d0\uc11c \ubcf5\uc6d0\ud558\ub294 \ubc29\ubc95\uc740.
\n1. \ub611\uac19\uc740 \ub514\ube44\uba85\uc73c\ub85c \ub514\ube44\ub97c \uc0dd\uc131\ud558\uace0
\n2. \ud480\ubc31\uc5c5\uc744 \ud55c\ud6c4
\n3. \ub611 \uac19\uc740 \ud30c\uc77c\uba85\uc73c\ub85c \uc5ce\uc5b4\uce58\uba74 \ub41c\ub2e4.<\/p>\n
\ud558\uc9c0\ub9cc \uc774\ub54c \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294\ub370..
\n\uc0ac\uc6a9\uc790\uba85\uc774 \uac19\uc544\ub3c4 \uc11c\ubc84\uac00 \ud2c0\ub9ac\uba74 \ub2e4\ub974\uac8c \uc778\uc2dd\ud574\uc11c..
\n\ub85c\uadf8\uc778\uc774 \uc548\ub418\ub294 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n
\uc774\ub54c\uc5d0\ub294..
\n\uc77c\ub2e8 \uc18c\uc720\uc790\ub97c dbo\ub85c \ubc14\uafbc\ud6c4..
\n\ud2b9\uc815 \uc18c\uc720\uc790\ub97c \ub2e4\uc2dc \ub9cc\ub4e4\uc5b4 \uadf8 \ub514\ube44\uc758 \ud14c\uc774\ube14\ub4e4\uc744 \uadf8 \uc18c\uc720\uc790\ub85c \ub9e4\uce6d\uc2dc\ucf1c\uc8fc\uba74
\n\ub41c\ub2e4.<\/p>\n
\uadf8\ub54c \uc4f8\uc218 \uc788\ub294 \ud504\ub85c\uc2dc\uc800\ub97c \uc544\ub798\uc5d0 \uc801\uc5c8\ub193\uc558\ub2e4.
\n\uc720\uc6a9\ud558\uac8c \uc4f0\uc2dc\uae38<\/p>\n
\/*
\nVersion: SQL Server 7.0\/2000
\nCreated by: Alexander Chigrik
\nhttp:\/\/www.MSSQLCity.com\/ – all about MS SQL
\n(SQL Server Articles, FAQ, Scripts, Tips and Test Exams).<\/p>\n
This stored procedure can be used to run through all of a specific
\ndatabase’s objects owned by the ‘oldowner’ and change the old
\nowner with the new one.
\nYou should pass the old owner name and the new owner name,
\nas in the example below:<\/p>\n
EXEC ChangeAllObjOwner @oldowner = ‘John’, @newowner = ‘Alex’
\n*\/<\/p>\n
IF OBJECT_ID(‘ChangeAllObjOwner’) IS NOT NULL DROP PROC ChangeAllObjOwner
\nGO<\/p>\n
CREATE PROCEDURE ChangeAllObjOwner (
\n @oldowner sysname,
\n @newowner sysname
\n)
\nAS
\nDECLARE @objname sysname
\nSET NOCOUNT ON<\/p>\n
–check that the @oldowner exists in the database
\nIF USER_ID(@oldowner) IS NULL
\n BEGIN
\n RAISERROR (‘The @oldowner passed does not exist in the database’, 16, 1)
\n RETURN
\n END
\n–check that the @newowner exists in the database
\nIF USER_ID(@newowner) IS NULL
\n BEGIN
\n RAISERROR (‘The @newowner passed does not exist in the database’, 16, 1)
\n RETURN
\n END<\/p>\n
DECLARE owner_cursor CURSOR FOR
\n SELECT name FROM sysobjects WHERE uid = USER_ID(@oldowner)<\/p>\n
OPEN owner_cursor
\nFETCH NEXT FROM owner_cursor INTO @objname
\nWHILE (@@fetch_status <> -1)
\nBEGIN
\n SET @objname = @oldowner + ‘.’ + @objname
\n EXEC sp_changeobjectowner @objname, @newowner
\n FETCH NEXT FROM owner_cursor INTO @objname
\nEND<\/p>\n
CLOSE owner_cursor
\nDEALLOCATE owner_cursor
\nGO
\n==========================================
\n\uc4f0\ub294 \uba85\ub839\uc5b4\ub294
\nEXEC ChangeAllObjOwner @oldowner = ‘dbo’, @newowner = ‘kdemo’<\/p>\n","protected":false},"excerpt":{"rendered":"
\ub85c\uceec\uc11c\ubc84\uc5d0 backup\ubc1b\uc558\ub358 .bak\ud30c\uc77c\ub85c.. \ub2e4\ub978 \uc11c\ubc84\uc5d0\uc11c \ubcf5\uc6d0\ud558\ub294 \ubc29\ubc95\uc740. 1. \ub611\uac19\uc740 \ub514\ube44\uba85\uc73c\ub85c \ub514\ube44\ub97c \uc0dd\uc131\ud558\uace0 2. \ud480\ubc31\uc5c5\uc744 \ud55c\ud6c4 3. \ub611 \uac19\uc740 \ud30c\uc77c\uba85\uc73c\ub85c \uc5ce\uc5b4\uce58\uba74 \ub41c\ub2e4. \ud558\uc9c0\ub9cc \uc774\ub54c \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294\ub370.. \uc0ac\uc6a9\uc790\uba85\uc774 \uac19\uc544\ub3c4 \uc11c\ubc84\uac00 \ud2c0\ub9ac\uba74 \ub2e4\ub974\uac8c \uc778\uc2dd\ud574\uc11c.. \ub85c\uadf8\uc778\uc774 \uc548\ub418\ub294 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud55c\ub2e4. \uc774\ub54c\uc5d0\ub294.. \uc77c\ub2e8 \uc18c\uc720\uc790\ub97c dbo\ub85c \ubc14\uafbc\ud6c4.. \ud2b9\uc815 \uc18c\uc720\uc790\ub97c \ub2e4\uc2dc \ub9cc\ub4e4\uc5b4 \uadf8 \ub514\ube44\uc758 \ud14c\uc774\ube14\ub4e4\uc744 \uadf8 \uc18c\uc720\uc790\ub85c \ub9e4\uce6d\uc2dc\ucf1c\uc8fc\uba74 \ub41c\ub2e4. \uadf8\ub54c \uc4f8\uc218 \uc788\ub294 \ud504\ub85c\uc2dc\uc800\ub97c … \uacc4\uc18d \uc77d\uae30 “mssql \ub514\ube44 \ub2e4\ub978\uc11c\ubc84\uc5d0\uc11c \ubcf5\uc6d0\ud558\uae30”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1347","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1347"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1347\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}