tags:

views:

72

answers:

1
+1  Q: 

Intercept/Log all database calls to SQL Server from a .Net Assembly

Is there a way to intercept/log all database calls from a .Net Assembly. The primary purpose is to log all TSQL statements generated and send to SQL Server database from any of the businss logic layer assembly. This mechanism should be available at global level and not required to be applied at each assembly. This mechanism should be unlike SQL profiler in that it should provided with a stack trace which generated the SQL statement.

The purpose of such mechanism is to log all sql statments generated by an application and apply some analysis on it. This question is in regards to ADO.net technology.

A: 

The database is capable of logging all queries regardless of what application makes the query. Take a look here.

Fragsworth  2009-12-07 06:01:28
I am not looking on the database side. How would you log the stack trace in that case?I want to log the SQL statements along with the .net stack trace of it.
Anand Patel  2009-12-07 06:22:04
You need appropriate permissions to set this up. Therefore not possible in production scenario
Alexander Abramov  2010-01-11 14:03:37

related questions

Backup SQL Schema Only?
Sql to query a dbs scheme
Timer-based event triggers
Sql query, count and group by
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting
How do I use T-SQL Group By
What all do I need to escape when sending a (My)SQL query?
Split String in SQL
Datatable vs Dataset
ASP.NET MVC "CRUD" Database Sample
Convert HashBytes to VarChar
Best Book for a new Database Developer
What is the best way to avoid SQL injection attacks?
What language do you use for Postgresql triggers and stored procedures?
What is the best way to handle multiple permission types?
How do I index a database field
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
Is there a version control system for database structure changes?
How to export data from SQL Server 2005 to MySQL
ASP.NET Site Maps
Decoding T-SQL CAST in C#/VB.net
Flat File Databases in PHP