The database name is stored a part of the database properties, so you'll need to attach the first one, rename it, then attach the second.
>Hi,
>
>By duplicate (in the title) I mean: take one of my databases and add the same database to the SQL server under a different name. I am think of doing the following:
>1. Detach the "original" database
>2. Copy two database files to some different name
>3. Attach both databases
>Will this work? Or what is a better way of accomplishing my task? TIA.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer