Transaction log

Last Post 14 Aug 2009 08:13 AM by brianmultilanguage. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
brianmultilanguage
New Member
New Member

--
14 Aug 2009 08:13 AM
1. I have had zero luck in finding a way to query a transaction log.
The cause for my search is this:

Order#1
Order#2 (missing)
Order#3

The order table has 1 and 3 but not 2. My theory is that a user has found a way to not save an order and I was hoping to find it in the transaction log.

Of course if someone has a better idea, glad to hear it.


2. How can I track queries run w/o suffering performance issues on sql?
EVENT # 99375
EVENT LOG Application
EVENT TYPE Error
SOURCE MSSQL$DB
CATEGORY Server
EVENT ID 701
USERNAME domain\Administrator
COMPUTERNAME server
DATE / TIME 8/14/2009 4:56:13 AM
MESSAGE There is insufficient system memory to run this query.

BINARY DATA 0000: BD 02 00 00 11 00 00 00 0B 00 00 00 43 00 4C 00
0010: 49 00 2D 00 49 00 4F 00 53 00 5C 00 44 00 42 00
0020: 00 00 07 00 00 00 74 00 65 00 6D 00 70 00 64 00
0030: 62 00 00 00
You are not authorized to post a reply.

Acceptable Use Policy