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.
Author |
Topic |
Mehdi
Yak Posting Veteran
64 Posts |
Posted - 2010-03-11 : 07:18:44
|
Hi,I need to write a database anomaly detection program...I want to trace sql and getting these values• User ID• Group ID• Process ID• Session ID• Host ID & IP address• Object ID• Event: It describes the type of transaction performed or attempted on a particular data object.• Completion: It describes the result of an attempted operation. A successful operation returns the valuezero, and unsuccessful operations returns the error code describing the reason for the failure.• Transaction Time: The time at which the events or state changes are registered in the computer system.The total value of the user session is calculated based on this transaction time.I need the exact range of all the properties of above but I cant find any documentation regarding them..is ther any thing on them to show me the range of them since I need to encode them_____________Mehdi.software student. |
|
shebert
Yak Posting Veteran
85 Posts |
Posted - 2010-03-11 : 10:56:21
|
there may be DMV that could do this for you..http://msdn.microsoft.com/en-us/library/bb510744.aspx |
|
|
|
|
|