All the objects that should be in the master database have type 'System' in
Enterprise Manager, and all the ones that shouldn't have type 'User'. You
can sort on the type column and then select the whole bunch and delete them.
You probably have to do that a few times as objects that are referenced by
other objects (tables referenced by froeign keys for example) can't be
deleted, but you will get there eventually.

--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.


"Ken" <ken88@hotmail.com> wrote in message
news:063501c35179$b7c9bc50$a401280a@phx.gbl...
> Hi
>
> I accidentally run a script that create all objects from a
> db into master db. Does anyone know how to undo this
> without affecting the critical and important objects on
> master db?
>
> Thanks
>
> Ken