Re: ISA SQL LOG IP octets

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Kamran Khan" <kkhan@xxxxxxxxxxxxxxxxx>
Date: Fri, 8 Sep 2006 00:26:17 +0500

Iam also seeking an answer for this, is there a way to see real IP instead
of 10 digits?
"RickyVene" <RickyVene@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:777FBCE6-8793-4255-B54C-903720F0DA6C@xxxxxxxxxxxxxxxx

Hi,

I'm using the log now on my sql 2005 with sql statement.

How do I convert the IP (10 digits) to real four octets IP?

Please advise.

Thanks,
Ricky

Prev by Date: Re: Timeouts to www.continental.com for past two days
Next by Date: Re: Citrix Server on the other side of a VPN
Previous by thread: Timeouts to www.continental.com for past two days
Next by thread: Not able to allow skype
Index(es):
- Date
- Thread

Relevant Pages

Re: How many pre-decimal positions/integer digits has a DECimal (5,3) defined field ?
... Per ANSI SQL, for DECIMAL, the RDBMS is allowed you to give you a higher precision than you asked ... In SQL Server, they are the same. ... >> Does 5 represent the total numer of digits or only the number ... > In Oracle, you can also specify 'NUMBER' which stores 5 digits ...
(microsoft.public.sqlserver.programming)
Re: DAO MUCH faster than ADO in this test
... FROM tblNum, tblNum AS tblNum_1, tblNum AS tblNum_2, tblNum AS tblNum_3, ... When you are done go to Google and do a search on Sql Cartesian Product ... >> boost comes from an optimal design for whatever operation ... >> Digits with a single field named Digit. ...
(microsoft.public.access.modulesdaovba)
Re: DAO MUCH faster than ADO in this test
... the "loop" time is negligible in comparison with the user ... the SQL way to do it would be through a single statement. ... >> boost comes from an optimal design for whatever operation ... >> Digits with a single field named Digit. ...
(microsoft.public.access.modulesdaovba)
Re: Tricky file import problem using vba
... That is for *each* MDB. ... If you don't think that 2GB is enough, you could use SQL Express. ... where the first 4 digits represent an ID ... alpha character identifies a file belonging to the group for that month. ...
(microsoft.public.access.modulesdaovba)
Re: SQL Insert Problem - Precision Invalid
... This is meant to insert 3 values from an ASP page into a MS SQL db. ... description "The precision is invalid." ... When user_id is 10 digits long it works?! ... This email account is my spam trap so I ...
(microsoft.public.inetserver.asp.db)