SQL Server Performance

Connection Property

Discussion in 'General DBA Questions' started by homnath_sharma, Oct 23, 2006.

  1. homnath_sharma New Member

    Hi,

    Could you anyone let me know whats the equivalent command of below in MSSQL Server2000.

    In SybaseSQL Anywhere

    connection_property ( { property-id | property-name } [, connection-id ] )
    Returns the value of the given property as a string. The current connection is used if the second argument is omitted.

    eg:
    select connection_property('NUMBER')
    output:
    connection_property('NUMBER')
    1057111593

    So, I would like to know the equivalent command in MSSQL2000 for the above function.

    Thanks n Regds.
    ~ HNS ~

Share This Page