System IP in Stored Procedure

[User 4005525]

Hi, I have One SP in Sql Server 2005.In that SP i need to get the IP number of the Local System. Can anyone tell me How? thanks in Advance sri

[N a v a n e e t h]

Member 4008492 wrote:

IP number of the Local System

Local system ? You won't get IP address in a Stored Procedure. You can pass it as a parameter from outside.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

[DerekFL]

If this is only internal network you can use SELECT HOST_NAME() giving you the name of the computer. You could then create a CLR proc to get the IP.