Cheers Gilla, have read a few blogs and articles about it and it would appear that if all else fails, recreate the database and import the data back across.

Don't suppose you have any links to threads about doing this in a nice powershell script??