Loading

log sql query execution

Abhilash J A

10y894SQL

SQL Server 2008 - I have a BigQuery contain select query with multiple sub queries,temp table, lot of if conditions.
How to see which select query sub query is return null or value and see temp table's data, terminate or not if conditions such
things? Is it possible to create LOG table to see the query execution ? If creating LOG table is such a good way, then how to use
LOG table in the Bigquery? Kindly advise me, please.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Krishna Rajput Singh10y ago
Hello Abhilash Jayakumar thanks for writing below links i hope helpful for you..:)

https://msdn.microsoft.com/en-IN/library/ms159110.aspx

http://dba.stackexchange.com/questions/4043/can-i-see-historical-queries-run-on-a-sql-server-database

http://www.jochenhebbrecht.be/site/2013-03-30/database/logging-all-queries-executed-mssql-database

If you found this useful Please Accept this as Answer