1. there is no problem with the data.. you have to execute the query to see the results because the data explorer will not refresh by itself, even if the data has changed, so there is no problem with that..
2.If you SP sometimes not insert the data, you should better check for that conditions before running the SP and avoid them, if you are doing validations on the SP (and that what you refers by conditions), you better validate the data before. If you however want to do it within the SP, a executenonquery will return the number of affected rows, if that is 0 then you didn't do anything...
Read this if you want to know how to get a correct reply for your question:
^^Took that from dparsons signature and he Took that from planoie's profile
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
I know that CVS was evil, and now i got the proof: