python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - extended-events

Extended Events for Server/Database Audit

I am wanting to know if anyone is aware if there is an Extended Event I could utilize to detect if a SQL server/database audit definition has been altered, created, deleted, etc. Currently I am utiliz...
test-img

Pushpin29

sql-server

audit

extended-events

Votes: 0

Answers: 1

Latest Answer

Any Audit will track its own starts and stops under the Audit Session Changed (AUSC) event. I created an Audit on my local instance and merely enabled/disabled it and then ran the following query: sel...
test-img

Ben Thul

count of all records stored Extended Event

I want to get count of all records stored in Extended Event but that file is a huge and running a query on it takes several minutes and does not meet my need. I wanted to know is there any place in th...
test-img

Mohammad Safyar

sql-server

count

extended-events

Votes: 0

Answers: 1

Latest Answer

You can export it to csv file as, it is explained in this link Then, you can import the csv file into a sql server using Bulk insert Bulk insert execution is very fast unless you don't use indexes in ...
test-img

Kemal AL GAZZAH

Posts

Questions

Blogs

Jobs