Not throwing exeception while creating a stored proc if dependent objects do not exist

• anand.mind

  Say Hey Kid

  Points: 699

  More actions

  September 18, 2013 at 1:57 am

  #277312

  Hi,

  While creating a stored procedure in SQL Server 2008 Standard Edition, it is not throwing any execption and created successfully even if the table it is operating on, does not exist. Is there any settings that I have to enable?

  Please guide me.

  Thanks & Regards,

  Kumar Anand

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  September 18, 2013 at 3:45 am

  #1651040

  Check this link about Deferred name resolution you will find the answer:

  http://technet.microsoft.com/en-us/library/ms190686(v=sql.105).aspx

  _______________________________________________________________
  To get quick answer follow this link:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/