Need help in printing Errors

• Rao.V

  Hall of Fame

  Points: 3452

  More actions

  June 20, 2008 at 4:24 am

  #122830

  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

• Rao.V

  Hall of Fame

  Points: 3452

  More actions

  June 26, 2008 at 2:38 am

  #834465

  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.

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  June 27, 2008 at 1:16 pm

  #835599

  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

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]