CREATE PROCEDURE RefreshAllView
AS
DECLARE MyCursor CURSOR
FOR
SELECT Name
FROM dbo.sysobjects
WHERE OBJECTPROPERTY(id, N'IsView') = 1
AND ( NOT name IN ( 'sysconstraints', 'syssegments' )
)
DECLARE @name VARCHAR(40)
OPEN MyCursor
FETCH NEXT FROM MyCursor INTO @name
WHILE ( @@fetch_status <> -1 )
BEGIN
IF ( @@fetch_status <> -2 )
BEGIN
EXEC sp_refreshview @name
END
FETCH NEXT FROM MyCursor INTO @name
END
CLOSE MyCursor
DEALLOCATE MyCursor
AS
DECLARE MyCursor CURSOR
FOR
SELECT Name
FROM dbo.sysobjects
WHERE OBJECTPROPERTY(id, N'IsView') = 1
AND ( NOT name IN ( 'sysconstraints', 'syssegments' )
)
DECLARE @name VARCHAR(40)
OPEN MyCursor
FETCH NEXT FROM MyCursor INTO @name
WHILE ( @@fetch_status <> -1 )
BEGIN
IF ( @@fetch_status <> -2 )
BEGIN
EXEC sp_refreshview @name
END
FETCH NEXT FROM MyCursor INTO @name
END
CLOSE MyCursor
DEALLOCATE MyCursor
