binding errors after table swap

  • Try sp_refreshview.

    sp_refreshview [ @viewname = ] 'viewname'

    From BOL :

    Updates the metadata for the specified non-schemabound view. Persistent metadata for a view can become outdated because of changes to the underlying objects upon which the view depends.

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply