How do you create these now ?

What i would do was to add at check to your code, that checks if the id exists, if it does add a number...

I have used this tool a couple of times, It might come in handy 4 you.

http://www.albahari.com/queryexpress.aspx

/MSC

hi,

why restore? Why not try to get the database out of suspect mode, or find out why it is in suspect mode ?

nothing, the old datetime datatype is still supported in SQL-Server 2008

why dont you put your SQL code into a view, and let your users use that