Store Procedure compilation not giving error if table does not exist like SQL6.5.
-
With SQL 2000 when I compile a Store Procedure it does not give any error if the table name is either missing or wrongly defined. The document states that without having a table defined the Queries can be built which is the feature of the SQL2000 which is good. But at the same, time I am sure there must be a way to force to give the error while compiling the procedures so that instead of error being thrown at the time of run-time the same can be caught while compilation.
In SQL6.5 if table is not specified in the database compilation would give error. Any switch (Not SQL65 compatability) is available either at isql or isqlw utilites or at the Server configuration (sp_configure). Is there any undocumented procedure that is available which can be set to see the error duing compilation.
S.Krishnan
-
One cool feature of "deferred name resolution" is that no matter what you do wrong, you can't accidentally turn it off.
Cheers,
- Mark
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply