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 ~
