Thanks for the reply and am sorry without giving much details about the problem statement
It is website, and the business logic for some core functionality is written in store procedures. The website will be installed into the client pc locally. so there is chance to view the business logic and modify it. i want to prevent my code. so i was asking what all the best methods to prevent the store procedure code. i know some of the methods like we can use encryption keyword. and there is one more way where we can use .net CLR integration with store procedure, but i dont know how to do that. if you know could you please suggest the steps and advice it is the better approach.
i hope it make sense now.