There is an sp that validates the metadata and the same sp we can use to validate
set nocount on
select ' print ''' +name +'''
exec sp_refreshview ['+name+']' + CHAR(10)+ '
go '
from sys.views
Execute the above script it will give script to run sp_refreshview on all views. Run the scripts generated using above sql statement I will give error link below screen
No comments:
Post a Comment