dbcc cis (showcaps, SERVERNAME) vallues - 04-27-2007 , 08:58 AM
when I type dbcc cis(showcaps, SERVERNAME)
I see the list of capabilities supported by SERVERNAME, and
Unfortunately, I have been unable to determine what those
values actually correspond to.
For example, capability 102 is "join handling" the
documentation *I* could find says that
1=No outer join supported
yet if I connect to an ASE server, it tells me that the
value is "6". 6? what does that mean....
Similarly, the values 101-147. What does the CapValue
actually correspond to?
In most cases, 0 is not enabled, 1 is enabled, but obviously
there are other values as well.
Does anyone know? Thanks
Re: dbcc cis (showcaps, SERVERNAME) vallues - 05-01-2007 , 05:37 AM
Geoff G wrote:
And, by all means, if you do find out, please post a reply
here so that it can be archived for future reference.
-am © 2007
Re: dbcc cis (showcaps, SERVERNAME) vallues - 05-03-2007 , 12:50 AM
Usually these capability values are fixed for a certain remote backend and
won't need to be changed at all.
The value 6 in cap 102 means it supports TSQL and ANSI joins.
<Geoff G> wrote