I see. In other words every time we open the SP with modify procedure command the SP is getting compiled behind the scene and all the constants are getting included inside the compiled code, right?
>It's compile time directive not a command.
>
>>At the top of the Stored procedure in our database we have #INCLUDE '\MMORTALS\COMMON30\INCLUDE\FRAMEWRK.H' In production we don't have the same directory structure as we have in development. The framework.h is included in the project. Do you see any problems using it this way?
>>
If it's not broken, fix it until it is.
My Blog