title: SQL script to "copy" a database
body: <p>I want to write a SQL script that will copy a database on the same server.  I could do a backup/restore, but I think it might be faster to just "copy" somehow.  Does anyone know if this is possible?  Is there a way to write a script that will just detach, copy the file on the HD, and then reattach both copies?</p>