Using Global Variables to Determine Status

Component Integration Services adds a number of global variables.

  • @@cis_rpc_handling

  • @@transactional_rpc

  • @@textptr_parameters

  • @@stringsize

  • @@bulkbatchsize – contains the value of the current cis bulk insert batch size configured via sp_configure, or set through the set bulk batch size command.

  • @@bulkarraysize – contains the value of the current cis bulk insert array size configured via sp_configure or set through the set bulk array size command.

These global variables show the current status of the corresponding configuration parameters. For instance, to see the status of cis_rpc_handling, issue the following command, which returns either 0 (off) or 1 (on):
select @@cis_rpc_handling
Parent topic: Configuration and Tuning