<div>
Hate to say this but you cannot
</div>


<div>
make that 3 to say: sorry ...
</div>


<div>
Also, SELECT statements will never be in the tran log...only DML statements, such as INSERT, UPDATE, DELETE...and then only if you're in FULL recovery model.
</div>


Also, SELECT statements will never be in the tran log...only DML statements, such as INSERT, UPDATE, DELETE...and then only if you're in FULL recovery model.

<div>
Since you responded first, I'll give you the points. Thanks everyone.
</div>


Since you responded first, I'll give you the points. Thanks everyone.

<div>
<div class="content wysiwyg-content">
I'm using MS SQL 2000 Server. A few weeks ago I ran a fairly complex query against the database. Unfortunately I didn't save this query, now I need to run this same report. Is it possible for me to find this query in the sql transaction history logs? Can I do a search for part of my query to find it?<br />

</div>
</div>


I'm using MS SQL 2000 Server. A few weeks ago I ran a fairly complex query against the database. Unfortunately I didn't save this query, now I need to run this same report. Is it possible for me to find this query in the sql transaction history logs? Can I do a search for part of my query to find it?


How to find a query in the SQL transaction log?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.