现在我检查所有存储过程的语法的解决方案是进入企业管理器,选择列表中的第一个存储过程,并使用以下过程：

>输入
> Alt C
逃脱
逃脱
>向下箭头
>转到1

它的作品,但它是相当乏味.我想要一个叫做的存储过程

SyntaxCheckAllStoredProcedures

像我写的其他存储过程一样,对于视图也是一样的：

RefreshAllViews

为了大家的好处,RefreshAllViews：

RefreshAllViews.prc

CREATE PROCEDURE dbo.RefreshAllViews AS

-- This sp will refresh all views in the catalog. 
--     It enumerates all views,and runs sp_refreshview for each of them

DECLARE abc CURSOR FOR
     SELECT TABLE_NAME AS ViewName
     FROM INFORMATION_SCHEMA.VIEWS
OPEN abc

DECLARE @ViewName varchar(128)

-- Build select string
DECLARE @sqlString nvarchar(2048)

FETCH NEXT FROM abc 
INTO @ViewName
WHILE @@FETCH_STATUS = 0 
BEGIN
    SET @sqlString = 'EXECUTE sp_RefreshView '+@ViewName
    PRINT @sqlString
    EXECUTE sp_Executesql @sqlString

    FETCH NEXT FROM abc
    INTO @ViewName
END
CLOSE abc
DEALLOCATE abc

为了所有人的好处,存储过程将所有存储过程标记为需要重新编译(标记重新编译的存储过程将不会告诉您是否在语法上有效)：

RecompileAllStoredProcedures.prc

CREATE PROCEDURE dbo.RecompileAllStoredProcedures AS

DECLARE abc CURSOR FOR
     SELECT ROUTINE_NAME
     FROM INFORMATION_SCHEMA.routines
    WHERE ROUTINE_TYPE = 'PROCEDURE'
OPEN abc

DECLARE @RoutineName varchar(128)

-- Build select string once 
DECLARE @sqlString nvarchar(2048)

FETCH NEXT FROM abc 
INTO @RoutineName
WHILE @@FETCH_STATUS = 0 
BEGIN
    SET @sqlString = 'EXECUTE sp_recompile '+@RoutineName
    PRINT @sqlString
    EXECUTE sp_Executesql @sqlString

    FETCH NEXT FROM abc
    INTO @RoutineName
END
CLOSE abc
DEALLOCATE abc

为了完整起见,UpdateAllStatistics过程.这将通过执行完整的数据扫描来更新数据库中的所有统计信息：

RefreshAllStatistics.prc

CREATE PROCEDURE dbo.RefreshAllStatistics AS

EXECUTE sp_msForEachTable 'UPDATE STATISTICS ? WITH FULLSCAN'