I have configured Miscrosoft SharedPoint server 2007 with SQL server 2005. Everything is going fine. One thing I need to know how the transaction commits in SQL server when I Check in and check out a document or make a workflow in SharedPoint server 2007. For clarity, If I create/import a document via SharedPoint, how I can see the changes in the SQL server tables? i.e. what tables and which columns have been modified for the above transaction. Is there any LOG tracer in SQLServer 2005 where I can get the information of those transactons.
I don't want to see those changes by simply executing the queries going each table. Is there any log tracer or any way?