Hi Laura,
Did the blog have entries, or was it just a blog that was created? Do you know what the UserID was for the user that was deleted?
Actually, you can do this (after backuping up your database:)):
From the Host | SQL tool, execute the following:
SELECT blogID, UserID, Title from {databaseOwner}{objectQualifier}Blog_blogs
In the list, find the BlogID that you want to delete. Note this ID, its referenced in the SQL below as n. Then execute this:
SELECT EntryID, Title from {databaseOwner}{objectQualifier}Blog_Entries WHERE BlogID = n
At this point, you're just checking to see if there are entries. If there are, then you can execute the following SQL to see if there are comments:
SELECT e.EntryID, e.Title, c.Title from {databaseOwner}{objectQualifier}Blog_Entries e JOIN {databaseOwner}{objectQualifier}Blog_Comments c ON e.EntryID = c.EntryID WHERE BlogID = n
If there are comments, you can delete them all by running the following (you'll check the Run as Script checkbox for this statement):
DELETE FROM {databaseOwner}{objectQualifier}Blog_Comments from {databaseOwner}{objectQualifier}Blog_Entries e JOIN {databaseOwner}{objectQualifier}Blog_Comments c ON e.EntryID = c.EntryID WHERE BlogID = n
Then run the following to delete all the entries (remember to check the Run as Script option):
DELETE FROM {objectQualifier}Blog_Entries WHERE BlogID = n
Finally, you can delete the blog itself by running the following SQL using the Run as Script option:
DELETE FROM {objectQualifier}Blog_Blogs WHERE BlogID = n
Hope this helps,
Don