dbcc Options

Component Integration Services includes a number of dbcc parameters.

remcon – displays a list of all remote connections made by all Component Integration Services clients. It takes no arguments.
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 – displays a list of all capabilities for servername by capability name, ID, and value as follows:
```
showcaps, servername
```
For example:
```
dbcc cis(“showcaps”, “servername”)
```