Getting client IP adresses?

[kalto]

Is there a function in SQL Server that can get the IP address of the client running the query?

Like "SELECT something, fn_clientipaddr() AS ipaddr FROM some_table" would returns something like that:

something ipaddr
--------- ------
somevalue 192.168.0.1

192.168.0.1 being my IP

Anyone got a hint?

 

[vongrunt]

AFAIK the closest match is master.dbo.sysprocesses... net_address contains NIC address.

 

[kalto]

I guess i could work with that.

The other question is, how can i get my SPID?

 

[vongrunt]

select @@spid

 

[kalto]

Thanks again

I got another question tough.

I just realised that you can't use the "USE" statement in a view or functions, so my question is, how can i access the master database from a view?

 

[vongrunt]

Through [[[server.]database.]owner.]object syntax:

create view v_blahview
as
select * from master.dbo.sysprocesses