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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 IP Address of Client

Author  Topic 

danasegarane76
Posting Yak Master

242 Posts

Posted - 2007-07-10 : 10:46:05
Dear All,
How can store the IP address of the client as default value in a column

Thanks in Advance
Dana

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-10 : 11:17:25
How do you get that address?
Go to Top of Page

danasegarane76
Posting Yak Master

242 Posts

Posted - 2007-07-10 : 11:26:30
HOST_ID function ?
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-10 : 13:16:14
and where did you get the idea that the host_id returns the ip of the client???

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-10 : 13:19:00
Sql server can only get mac address as I know.
Go to Top of Page
   

- Advertisement -