BTW:
You also need to CAST the @Success variable to VARCHAR in you concatenation code for the email body:
+ char(10) + 'Success'+CAST(@Success AS VARCHAR)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]