August 3, 2009 at 11:15 am
I'm building a full build script for our production database, and tripping on a DELETE statement executed on the table variable declared as the output of the function. I get an error stating that I can't use side-effecting statements in a function. The author of the function is able to build the same - all against the same databases that are rejecting my attempts at same. I have SSMS 2005 and 2008 and am getting the same result for each. My colleague is using only 2005. We are in the same groups.
It should build (delete statements are allowed against table variables), but can anyone think of local settings that would effect whether this works?
Thanks in advance for any ideas!
Stephen Carpenter
August 3, 2009 at 11:22 am
I'm not really sure what your problem may be here. It would help to see the full error message and the code that you are having problems with.
August 3, 2009 at 2:37 pm
Red Herring - the message was occurring only in cases where there was a missing dependency. Once the dependency was resolved, the error was no longer being raised.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply