@pete-s said in Make MS SQL Server 2014 Log Every Query:
@romo said in Make MS SQL Server 2014 Log Every Query:
@pete-s said in Make MS SQL Server 2014 Log Every Query:
Extended Events
@Pete-S happen to know where the default location of the event files are saved?
I created a new session and I believe it is properly showing the queries ran, but if I try to change the place where the file is logged to is doesn't start, but if I leave the default set I can't find the file!!
I'm not sure the default is actually a file at all, it may be memory buffers.
However it sound like you have a user rights issue. Make sure SQL server is allowed to write to the file where you put it.
Also remember The SQL instance is usually not running with a user context. Generally a system service.