If the database is in full recovery, and you still have the log you can try using Lumigent's Log Explore or Quest's LiteSpeed to roll back the transaction and see if it will give you back the data. I'm 99% sure that it won't.
I'm pretty sure that you have lost the data.
If the database is in simple recovery mode, then the data is lost.
Last Wiki Answer Submitted: April 9, 2010 7:15 am by Denny Cherry64,505 pts.