How to determine connection data from translated log...

[Former Member]

Hi,

I had a problem with a database today where various rows were changed.

I translated the transaction log, and see the following:

--CONNECT-1018-06813851771-DBA-2012-12-05 08:08 --BEGIN TRANSACTION-1018-06813851782 BEGIN TRANSACTION go --UPDATE-1018-06813851783 UPDATE DBA.iInv SET Precio=.84, Precio1=.84, Precio2=.84, Precio3=.84, Precio4=.84, Precio5=.84, timeStampCambio='2012-12-05 08:08:12.096' WHERE Bodega=124000100 AND Item=227 go --UPDATE-1018-06813851836 etc...

I imagine the the first line has the connection information. With "1018" being the connection number, and the other number 06813851771 some type of serial id.

Is it possible to know the connection information. In particular I'm interested in knowing the IP and the machine details for that connection.

Is it possible?

Thanks, Edgard

[johnsmirnios]

That information is not logged since it is not needed for recovery. You can enable auditing to cause some of that information to be logged but if auditing wasn't enabled, that information will not be present in the logs you are looking at. See http://dcx.sybase.com/index.html#1201/en/dbadmin/auditing-security.html*d5e84361