I do have two registrations, but there should be nothing in common. I registered initially as tomk@tomkellerconsulting.net back when I wasn't sure about this site, as I filter that...

If FMTONLY is ON, all queries return zero rows, so a variable assignment in any select has no effect, and the variable keeps its previous value, which is NULL if...

Still not seeing any posts under "My Posts" except this thread, and yesterday I posted to:

http://www.sqlservercentral.com/Forums/Topic595515-1411-1.aspx

Good to know, and the reverse will also be useful! When you have to use a front end tool such as Excel or Access, which does not use FMTONLY, temporarily...

Thanks Steve! I don't think it should affect this, but just in case, note that I used my .net email to post both this and that. I have also logged...

In my case, it was necessary not only to show that a certain user ran a certain query at a certain time (as the trace would do), it was also...

I have had to satisfy a similar select-logging requirement, in an environment where management was worried about field sales reps selecting the database and taking it with them if they...

I've been using trigger-based Audit Trails since SQL6, and every customer I've set them up for has loved them. Although there have been some use cases for workflow reporting and...