How hard is it to determine what procedures/functions no longer compile?

Posted by Dave on Stack Overflow See other posts from Stack Overflow or by Dave
Published on 2010-06-09T15:27:51Z Indexed on 2010/06/09 15:32 UTC
Read the original article Hit count: 109

Filed under:

In sql server how difficult would it be to determine what procedures/functions no longer compile? In other words, if I scripted out alter statements for all procedures and functions in a database, I'd like to know which of these statements are going to fail?

I've been working on cleaning up a database I've inherited which has gone through years of changes and I'd like to what objects are going to raise errors when something tries to execute it.

© Stack Overflow or respective owner

Related posts about sql-server