If the dependency tree in SQL Server is up to date it works, but it isn't guaranteed. I'd agree with Grant, there isn't an easy way to do this. What you could do is just search, and if you find tables in stored procedure comments, go through and clean up the comments to change the table name in there to something that won't match.