SQL server 7.0 on win2000 server.
Client tried to restore then cancelled during restore. Database is now marked inaccessible. Database icon is greyed out and has (loading) beside it. If I try to run any stored procedures on the database it tells me that it is in the middle of a restore (Msg 927). The client has no backups (unbeleivable I know) so cannot restore from backup.
How do I restore the database if I can at all.