wow, that is a great script, you saved us hours of work. in the end we found 14 sp's that wouldn't parse/compile.

this script is going in my toolbox.

thank you very...

Did you mean to attach or link something?

Ok I found what was causing the "The current transaction cannot be committed ...." error, my sp calls another which in turn calls another sp and its the 3rd one...

I can run other transactions, but i run the sp that caused the prob I still get the error "The current transaction cannot be committed and cannot support operations that...

I just tried running the back using t-sql instead of the wizard, which did restore the db, but still the tempdb has uncommitted transactions! even after a restart of the...

forgot to mention that I had tried to restore a backup of the db that the sp was running in, but that didnt work.

I restored using the wizard with "overwrite"...

Thanks for the reply. I thought I would let you know how I managed to do this.

I changed the connection string to use a SQL Server login and then just...

Embed the next IIF in the false part of the previous:

IIF(Fields!Mark.Value> Fields!Target_Mark.Value AND Fields!Exam_Description.Value LIKE "*Real*", "Black", IIF(Fields!Exam_Description.Value LIKE "*Test*", "Brown", IIF(criteria for blue or red, "Blue","Red)))

Lee.