Skip to Content
Former Member
Feb 11, 2009 at 01:58 AM

Deleting the other schema in SQL 2005


Dear all,

Currently I am working in the system copy.

I will explain my scenario first then I will ask my queries.

In the source system its an MCOD database(One database three components were running i.e under ECC database , XI and BW were running)

Now we detached the database and copied the log and data files locally in to the NEW BW server.

In target system :

Installed central services instances.

Attached the database.

Ran the STM tool for the conversion.

Now BW server is up and running.

Queries. Since it is attached it also holds the data of other schema. Now in the new server i wnat only the BW schema and not other schemas.

How can i delete the other schema.Please suggest me with your valuble ideas.


Vijay Kumar