Grant is correct, if you put your database into 3rd normal form you will have to join. In my honest opinion getting 3nf is the most important part of getting...

we have a little app server and use a service account for monitoring - that should fix your issue

https://www.mssqltips.com/sqlservertip/3076/how-to-read-the-sql-server-database-transaction-log/

that might help

that's what fredeico's code does

he uses convert (date) to force it back to midnight

if it's that small a recordset and you aren't using procs, then i'm guessing it's an access client? - if it is then I think I might know the issue

On the subject of questions getting worse, here's what it has finally come to.  Notice in the zip file that there is absolutely everything that one might need to...

We had a person at my old job.  She was ALWAYS on the phone.  I got curious as to why and so I discreetly "hung around" for...

We had a person at my old job.  She was ALWAYS on the phone.  I got curious as to why and so I discreetly "hung around" for...

p.s.  I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies".  It there's not a well documented ticket to support the urgency,...

The scripts are better in...

So, for actively running queries, I recommend the DMVs, sys.dm_exec_requests is a good starting point. You can join that to other DMVs to get the execution plan, the SQL...

We had a person at my old job.  She was ALWAYS on the phone.  I got curious as to why and so I discreetly "hung around" for a couple...

oooh points, that gamification that gives you a sense of achievement on a website. sadly it's quite a hook for newbies, but you get a lot of "trawlers" that just...

only trying to offer up a different box of tricks

i'd love to hear if you find a generic solution. other than that "activity monitor" lol, but that requires you to...

there is a neat little trick you can do with profiler traces - make sure you capture the start event(RPC,statement whatever) as well as the end event

if you cant find...