March 21, 2002 at 5:50 am
Hi,
I don't know if I should say I am lucky or unlucky to have this feature included in SQL 2000.
Due to the feature listed, when I create a stored procedure without the objects which I refer to in my stored proc. SQL Server does not atleast warn me. And only if the particular statement gets executed does the error thrown on my face.
I want to know if it is possible to change this behavior by setting any flags..One way of doing this is to set the compatibility to 6.5 before compiling the proc and then set the same to 80 immediately after completion.
Any better ideas..
Regards,
Mitra
March 21, 2002 at 6:10 am
When I do this I always get a warning. Are you using straight sql in you proc or dynamic which it cannot see until execution?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 21, 2002 at 6:27 am
Hi,
If I am issuing a Select statement I don't receive any warnings.
If I try to execute a non-existent procedure then I get warnings.
Regards,
Mitra
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply