SQL Query Logging

[tbg130]

Hi All,

I have found a UDF that has helped me compare a value to a regular expression that is stored in SQL however, it seems to take forever when processing multiple records. I'm wondering if there is a way to log the action of the queries so I can understand what is actually happening in the back end.

The Regular Expression in the database represents an IP address range and I'm comparing those to an actual IP address. Just wondering how it loops through the Regular Expressions (if it loops at all; maybe it identifies match / no match immediately).

All in all, can I log the actions of the Queries to learn why it takes so long?

Thanks.

 

[sweth]

It is stored procedure , to troubleshoot you can create a log table with iterationid identity column and insert the intermediate results to study

 

[tbg130]

Sorry for my ignorance; I'm not much a programmer. Is that a couple lines of code that I would add to the UDF/Procedure?

Just would like to output the log to a .txt file...

Thanks.