DB Query Label not showing in log
Posted: Tue May 26, 2015 11:33 am
Is there a way to have the label for a query element show in the log file (Update Current Count in this example)? It would make it easier to review the log file without having to use debug or verbose logging.
<sql label="SQLSRVR" resourceId="SQLSRVR" autoCommit="true" version="1.0">
<query label="Update Current Count">
<statement>Update dbo.MyTable Set CurrentCnt = 0 Where Source = 'NEW'</statement>
</query>
</sql>
2015-05-26 12:10:51 INFO Executing sub-task 'query'
2015-05-26 12:10:51 INFO Query completed successfully and -1 row(s) were affected
2015-05-26 12:10:51 INFO Finished sub-task 'query'
If this doesn't exist, can I submit it as a suggestion?
<sql label="SQLSRVR" resourceId="SQLSRVR" autoCommit="true" version="1.0">
<query label="Update Current Count">
<statement>Update dbo.MyTable Set CurrentCnt = 0 Where Source = 'NEW'</statement>
</query>
</sql>
2015-05-26 12:10:51 INFO Executing sub-task 'query'
2015-05-26 12:10:51 INFO Query completed successfully and -1 row(s) were affected
2015-05-26 12:10:51 INFO Finished sub-task 'query'
If this doesn't exist, can I submit it as a suggestion?