Thanks for your response GilaMonster

Just wanted to make sure I cover all the bases.

None what so ever, did find this though http://support.microsoft.com/kb/2803799

Does not seem like good news

Thanks for the reply guys. Appreciate it

SQL Server R2, service pack 2

The query was :

"SELECT * from sys.dm_exec_procedure_stats where plan_handle = 0x05001400C4176E3B40819447060000000000000000000000"

It was running for 2 hours when they killed the process and it has been rolling back ever since.