June 20, 2008 at 4:24 am
Hi,
When ever we are restoring databases,while refreshing views of that particular databases some of the Views will not get refreshed 'Due to Binding Error'.
I have a procedure which refreshes all views of a database but i was not able to print the views which are not getting refreshed due to these binding errors.
Can anyone provide me the script or give any idea 'How I can print all view names which are not getting refreshed'
I tried using @errorcode option but no luck 🙁
Will be thankfull if i receive any solution ASAP
June 26, 2008 at 2:38 am
Any Suggestions Plz.
The error it is raising is of Severity level 16.So, Im unable to fix that level error.
Can anyone provide me a solution how to do this.
June 27, 2008 at 1:16 pm
Since a view is created using a SQL statement and that the table or one of the tables utilized in the view has had a column deleted or the column name altered will produce a binding error. View the attached image and see if it matches the error you are getting
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply