Tom,

<< I think "DROP DATABASE.." will delete all SPs or triggers/views for the
database. You'll need altering database path but there's no such sql.(only
altering description of database) >>

DROP DATABASE <DBName> KEEP CONTENTS

will not remove any of the contents of the database.  It will simply remove
the database from the configuration so that it doesn't exist any more in
that configuration.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< 1. I'm still asking questions myself
2. I'm not as polite or forbearing as you - how many customers would you
like to lose? >>

Good points.

--
Tim Young
Elevate Software
www.elevatesoft.com