The following global variables have been added for Component Integration Services users:
@@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:
select @@cis_rpc_handling
This returns either 0 (off) or 1 (on).
