I checked the SQLJob timings and the times this error occured.It seems to occur at random times.

Hello Phil, We see this once in a while and not a recent occurence. Twice in the last 30 days.Yes there is a SQLJob which inserts data into a different...

• This reply was modified 2 years, 1 month ago by mtz676.

Thanks Jeff and All for the detailed response

I agree an upgrade is long due, but they are application dependent; till that happens I need this code to work.How can I fix it meanwhile.

• This reply was modified 2 years, 4 months ago by mtz676.

But I need to capture information from databases whose compatibility_level is 80.

exactly.How do I overcome it.

Yes

1.SQL audit files are directly writen to the shared folder from across all servers to ServerA's shared folder.

2.Yes I can access the shared folder on ServerA from ServerB or ServerC...

@Grant Fritchey. Thanks for the response. Will do so.

• This reply was modified 3 years, 7 months ago by mtz676.
• This reply was modified 3 years, 7 months ago by mtz676.
• This reply was modified 3 years, 7 months ago by mtz676.

@Thanks Grant/All

What I need is to track whoever(Users only...not service accounts) has logged into the server and what have those logins done...dml's ..select..insert etc) and track the hostname,application name,database name.

Can...

• This reply was modified 3 years, 11 months ago by mtz676.
• This reply was modified 3 years, 11 months ago by mtz676.

@Grant and All

When I run a select  ... this is what I see in the result set under the statement column when all I want is...

• This reply was modified 4 years ago by mtz676.

I still see a lot of data. Is it possible to confine the result set to 1 record/row per dml activity in extended events.

@Grant

CREATE EVENT SESSION [MySession1] ON SERVER 
ADD EVENT sqlserver.sql_statement_completed(
ACTION(package0.collect_system_time,sqlserver.client_app_name,sqlserver.client_hostname,sqlserver.database_name,
sqlserver.server_principal_name,sqlserver.sql_text))
ADD TARGET package0.ring_buffer(SET max_memory=(10240))
WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,
MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)
GO


I have a smiliar session which dumps data into...

• This reply was modified 4 years ago by mtz676.

Hi All,

The host name is dependent on the connection string. If people leave this off, it's why you can't audit for it. You can use HOST_NAME to get this information...

@Thanks Jeff..I can check the error log way but can I get references on how I can filter the all data but the login records into the .xel files. By...

• This reply was modified 4 years ago by mtz676.