我正在尝试将闪电战更新到最新版本'7.95',@VersionDate = '20200506'。我收到以下错误
过程 [s p_Blitz],第 5863 行"FROM A"附近的语法不正确。
我得到的另一个错误是
过程 [s p 闪电战缓存]第 4814 行 无效的列名 pages_k b。
他们是此错误的修复程序吗?
对于任何感兴趣的人,这是尝试更新时会中断的所有过程。
The module 'sp_AllNightLog' depends on the missing object 'master.dbo.DatabaseBackup'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'sp_AllNightLog' depends on the missing object 'master.dbo.DatabaseBackup'. The module will still be created; however, it cannot run successfully until the object exists.
Msg 102, Level 15, State 1, Server [YourServerName], Procedure sp_Blitz, Line 5863
Incorrect syntax near 'FROMA'.
The module 'sp_BlitzFirst' depends on the missing object 'sp_BlitzWho'. The module will still be created; however, it cannot run successfully until the object exists.
您正在运行安装所有脚本.sql,正如您可能从其名称中猜到的那样,它会安装所有第一响应者工具包脚本。但是,其中一些依赖于其他第三方对象。
如果您只是尝试更新sp_Blitz,请只运行sp_Blitz.sql,或者运行安装核心闪电战无查询存储.sql。