catalog.check_schema_versioncatalog.check_schema_version

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

确定 SSISDB 目录架构与 Integration ServicesIntegration Services 二进制文件(ISServerExec 和 SQLCLR 程序集)是否兼容。Determines whether the SSISDB catalog schema and the Integration ServicesIntegration Services binaries (ISServerExec and SQLCLR assembly) are compatible.

如果该架构与这些二进制文件不兼容,则 ISServerExec.exc 将记录错误消息。The ISServerExec.exc logs an error message when the schema and the binaries are incompatible.

当 SSISDB 架构在应用程序修补和升级过程中发生更改时,该架构版本将递增。The SSISDB schema version is incremented when the schema changes during the application of patches and during upgrades. 建议您在还原 SSISDB 备份之后运行下面的存储过程,以确保架构和二进制文件兼容。It is recommended that you run this stored procedure after an SSISDB backup has been restored to ensure that the schema and binaries are compatible.

语法Syntax

catalog.check_schema_version [@use32bitruntime = ] use32bitruntime  

参数Arguments

[ @use32bitruntime= ] use32bitruntime[ @use32bitruntime= ] use32bitruntime
当此参数设置为 1 时,将调用 32 位版本的 dtexec。When the parameter is set to 1, the 32-bit version of dtexec is called. use32bitruntime 为 int 。The use32bitruntime is an int.

结果集Result Set

NoneNone

权限Permissions

此存储过程需要以下权限:This stored procedure requires the following permission:

  • ssis_admin 数据库角色的成员资格。Membership to the ssis_admin database role.