dbcc options

The following dbcc options are unique to Component Integration Services.

remcon

remcon displays a list of all remote connections made by all Component Integration Services clients. It takes no arguments.

srvdes

srvdes returns a formatted list of all in-memory SRVDES structures, if no argument is provided. If an argument is provided, this command syncs the in-memory version of a SRVDES with information found in sysservers. The command takes an optional argument as follows:

srvdes, [ srvid ] 

showcaps

showcaps displays a list of all capabilities for servername by capability name, ID, and value as follows:

showcaps, servername

Example 1

Example:

dbcc cis(“showcaps”, “servername”)