Here's the deal - we had a problem a few weeks ago and one of the guys deleted the log file. So, we created a new Database same name on different server. It doesn't have alot of room so the restore won't work there. All I really need is the table structure and stored procedures.

So, a moment ago I tried deleting the original database and it gave me an error 'alter database is not permitted while a database is in the restoring state' - how do I stop that. My guess is another IT person here tried a restore - and so it's been sitting in limbo for who knows how long. How do I stop that?