how to tell when dropping a column breaks a stored proc or view

Last Post 08 Oct 2010 01:13 PM by gunneyk. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
arzewski
New Member
New Member

--
30 Sep 2010 11:17 AM
when a developer uses SQL Server Management Studio, and drops a column that is either referenced by a view or inside a stored procedure, there is no error message that in dropping that column created a reference to a non-existing database object.

is there a tool that developers can use to detect such conditions ?

russellb
New Member
New Member

--
30 Sep 2010 07:35 PM
Can use DDL triggers for this
gunneyk
New Member
New Member

--
08 Oct 2010 01:13 PM
If you create the objects with schema binding it wont let you change them without dropping the bound objects first. Stored procs though dont have schema binding though.
You are not authorized to post a reply.

Acceptable Use Policy