Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-25 : 08:07:03
|
| SHAM writes "Hi,Could anyone let me know whats the equivalent command of below in MSSQL Server2000.In SybaseSQL Anywhereconnection_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')1057111593So, I would like to know the equivalent command in MSSQL2000 for the above function.Thanks n Regds.~ SHAM ~" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-25 : 08:15:46
|
| Maybe @@SPID is to use for you?Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Returns the value of the given property as a string