run the script I prepared to update all the views in the database.
Yusuf KAHVECI
yusufkahveci@sqlturkiye.com
www.sqlturkiye.com
Thanks
run the script I prepared to update all the views in the database.
Yusuf KAHVECI
yusufkahveci@sqlturkiye.com
www.sqlturkiye.com
Thanks
USE <Database_Name> GO DECLARE @sqlTrexec NVARCHAR(MAX)='' SELECT @sqlTrexec = @sqlTrexec + 'EXEC sp_refreshview ''' + name + '''; ' FROM sys.objects AS syso WHERE syso.type='V' EXEC (@sqlTrexec) --SELECT @sqlTrexec