I typically use BETWEEN; is that frowned upon? It just seems to look cleaner to me.

Though I can totally see how using the other way would require less pre-formatting.

/*...

Awesome! Thanks for posting that. Most of the time I wouldn't care about 3ms, but I am building a monitoring tool and I would rather not have something...

Just to try a new way to get the end of a day for a date comparison.

Didn't want to do the boring old string concatenation...

Need to learn to let go, and use DATETIME2...

Works fine when converted to DATETIME2 instead of DATETIME.

Found my answer here:

http://msdn.microsoft.com/en-us/library/ms187819.aspx

I have created my wheel, and I am hoping either the job outcome piece was a fluke (or a misunderstanding of what I was seeing).

Not sure where to check for the replication setting (I checked the publication properties and googled it and didn't get anything overly useful 🙂 )...either way I am not seeing...

How does transactional replication play into DMVs? The DMVs should only reflect the activity on the server, correct? Not activity from the publisher.

Thanks again!

I have checked at least five times 🙂 I will keep looking...

Thanks again, and if I find something I will post it here!

Could this be a plausible reason?

Hi Jarret,

Is the proc you are trying to watching is exec in a very high frequency? Is the sever a very busy server? I mean,...

I extended the trace, and am still not seeing it.

I am doing all columns for the following Events:

SP:Completed

SP:Starting

SP:StmtCompleted

SP:StmtStarting

I searched the object name and the text data columns for the procedure,...

I ran it for RPC:Completed and SQL:BatchCompleted.

I am pretty confused...I ran a trace on the server and waited for the execution count to increment, and after it incremented about 20 times I stopped the trace and...

I was hoping that wasn't the case 🙂

I can't explain why I am seeing the following:

cacheTime: 2012-06-18 15:00:10.4870000 ...

I will need to take note of that 🙂

Thanks again for the help!

I like it! I will stick with the earlier post (for the extra time it covers), but this one is really great!