Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

COPYING ALL DA THE DATBASE OBJECTS FROM DBO SCHEMA TO NEW SCHEMA Expand / Collapse
Author
Message
Posted Tuesday, June 8, 2010 3:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 26, 2013 10:08 AM
Points: 12, Visits: 38
HI,

I DETTACHED/ATTACHED A DATABASE FROM 2000 TO 2008.I AM PLANNING TO MOVE ALL THE DATABASE OBJECT FROM DBO SCHEMA TO A NEW SCHEMA "ABCD".I KNOW A PROCESS WHERE I CAN MOVE EACH DATABASE OBJECT INDIVIDUALLY,BUT I AM DEALING HERE WITH more than 300 tables and 400+ stored procedures etc etc.can anyone help me with a different solution where i can do that quickly.thank you.
Post #934283
Posted Wednesday, June 9, 2010 1:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Check the ALTER AUTHORIZATION (Transact-SQL) which may help you. Refer the following link:

http://technet.microsoft.com/en-us/library/ms187359.aspx

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #934432
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse