Is there a way to have SQL server validate object references in Stored Procs?
Posted
by Scott Weinstein
on Stack Overflow
See other posts from Stack Overflow
or by Scott Weinstein
Published on 2010-01-06T17:59:25Z
Indexed on
2010/04/17
15:13 UTC
Read the original article
Hit count: 156
The following code executes fine in SQL Server
create proc IamBrokenAndDontKnowIt as
select * from tablewhichdoesnotexist
Of course if I try to run it, it fails with
Invalid object name 'tablewhichdoesnotexist'.
Is there any way to compile or verify that Stored Proc are valid?
© Stack Overflow or respective owner