|
|
Posted by Erland Sommarskog on 08/22/06 22:22
Nacho (nacho.jorge@gmail.com) writes:
> I'm trying to follow some sql sentences that my system send to SQL 2005
> express and I don't have a deep knowlegde of databases. I know that
> there's a transactions log that keeps all sentences that go into
> database motor. Is it correct? in case yes, is there a way to look at
> this archived sentences?
The transaction log does not really have the SQL statements I believe,
but rather how they change the database. So this means that SELECT
statements are not there in any sense.
If you want to view the transaction log, you need to get a third-party
product like Lumigent Log Explorer or Log PI.
If you want to keep track of which statments that were sent to SQL Server,
a better alternative may be to run a trace. A trace can be run server-side
to a file, or client-side from SQL Server Profiler. The latter is probably
a better way to get started with tracing.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|