transfering multiple objects to another schema

Hot Topic

Cannot complete Install of Express
IO Stats and Execution Plans (text)
VB.NET 2003 STD WITH SQL SERVER EXPRESS
Gettint error "product level is insufficient" - did full re-install of SQL 2005 Standard Edition
Data Source error?
SQL authentication traffic for Mixed mode
Cannot create a connection to data source !!!! SSRS 2005
passing a column of values to the stored procedure
ForEach Loop utilisation
Cannot generate SSI Context

SQL Server

Splitted char values in table
SQL Server 2005 fails while installing on a cluster.
Expression Problem - GrandTotal
can MSRS 2000 run with .NET 2.0
Restoring just a table from a full backup
I don't remember how it was...
Global Temp tables
subreport linking problem
default schema not working?
Which Package Configuration Type is best

transfering multiple objects to another schema

I want to delete a user on local but in order to do that I apparently need to delete the schema. The schema has many objects in it. Can I and what is the syntax to move multiple objects from let's say XXX to dbo so I can delete the schema XXX

Thanks!

Answer this question

transfering multiple objects to another schema

  • John Faris

    Hey Mayomano,

    Check out the help topic on User-Schema Separation to get a better handle on how this all works.

    If you're goal is just to remove a User that currently owns a schema, it would be a better option to simply change the Schema Owner so that you can delete the User rather than move all the objects out of the Schema and delete the Schema just to get at the User.

    You should be able to do this using the ALTER AUTHORIZATION statement.

    Regards,

    Mike Wachal
    SQL Express team

    ----
    Mark the best posts as Answers!



  • clarkewu

    Did this solve your problem Mayomano

    Regards,

    Mike Wachal
    SQL Express team

    ----
    Mark the best posts as Answers!



  • transfering multiple objects to another schema
Answer this question