"Erland Sommarskog" <esq***@sommarskog.se> wrote in message
news:Xns98318000187A1Yazorman@127.0.0.1...
> (radhikaus***@gmail.com) writes:
>> i need 2 write a query to fetch the IP address of a system where i am
>> storing my data.
>> can any one what that query would be immediately.plz .
>
> If you want answer immediately, the you better provide more details. From
> where do you want to read this IP address? A table in your database? In
> such case what is the table definition?
>
> Or do you want to get the IP address of the server?
>
> Which version of SQL Server are you using?
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx