another option iam thinking right now is to create a udf that will call this executable sp. and the result will be call to my sp that will update the txtReferrence..