in SQL Server 2000 , I tried to compile a stored procedure which refers to a non existing table.
e.g.
Create Proc Usp_Try
as
begin
select * from Tbl_Non_exists
end
the table does not exists but the procedure gets created. and at run time it throws error. i want to stop this behaviour. i do not want any procedure to refer to any non-existing table. Is there any way to do it ??
Amit Jethva