How to find IP address or Cluster Name of SQL server 2000

Dear All,
Here is the scenario:
We have production and We have a DR Site.
The database is getting replicated from production sit to DR site using
log shipping.
Now the issue is:
We have unique transaction id for each transaction. For the
transactions being made at DR site, we want to have separate series.
Application uses stored proc to generate new transaction id id at
production. We want same stored procedure to handle this situation by
identifying SQL server instance name OR Cluster Name OR IP address and
generate the transaction id based on the findings.
Can anybody help me, how to find either of the three.
Thanks in advance.
AmarHi,

> identifying SQL server instance name OR Cluster Name OR IP address and
Have a look at SERVERPROPERTY() function in Books OnLine.
Robert
<emailtoamar@.gmail.com> wrote in message
news:1143535977.511229.222400@.i40g2000cwc.googlegroups.com...
> Dear All,
> Here is the scenario:
> We have production and We have a DR Site.
> The database is getting replicated from production sit to DR site using
> log shipping.
> Now the issue is:
> We have unique transaction id for each transaction. For the
> transactions being made at DR site, we want to have separate series.
> Application uses stored proc to generate new transaction id id at
> production. We want same stored procedure to handle this situation by
> identifying SQL server instance name OR Cluster Name OR IP address and
> generate the transaction id based on the findings.
> Can anybody help me, how to find either of the three.
> Thanks in advance.
> Amar
>