How to enable database logging in an ASP.net application

Question

How to enable database logging in my ASP.net application?

I am using VS2010 (ASP.net MVC2 project) and would like to see a log that highlights the database activity between the application and the database, including establishing a connection to the database (since somewhere I have a connection-related error).

I am using SqlServer Express 2008.

thank

Answer 1

I think your request is to enable and configure database auditing in SQL Server 2008.

http://www.sql-server-performance.com/articles/dba/Database_Audit_Specifications_in_SQL_Server_2008_p1.aspx

, , SQL Server Express Edition, .

, -. . . . ( , , ).

. SQL- SQL , , . , .

, , . , , , , .

.