They really can't.  The way of seeing this in EM is that IF you are the same permission-level or greater THAN you can see through the GUI IF not then...

1.  IF you are at the machine you can see if it gets hung after any remote connections are severed

2.  IF the machine doesn't come back up you are there...

How bout something like?

SELECT A1.HostName, A1.ApplicationName

  FROM AppUsers A1

    LEFT JOIN (SELECT HostName, ApplicationName

                 FROM AppUsers

               WHERE IsCustodian = 1)

    A2 ON A1.HostName = A2.HostName

      AND A1.ApplicationName = A2.ApplicationName

WHERE...

We use a Calendar table as well.  It has all sorts of uses for reporting and logging IF Holiday, EOQ, EOW, EOY, weekday/weekend, etc...

unfortunately, I am also joining the ranks of no money for Christmas party.  I just bought Laura a VERY expensize present.  We just bout a house and move in January...

change the password without telling anyone but your manager.  You will find out VERY quickly.

Seriously though..  I don't know of anything INTERNAL to SQL that will manage this.  Possibly IMCEDA...

We had to contact MS and they wound up coming on-site.  There are app. multi different ways of performing this and they may not always work.  In our shop they...

#1  Indexes are always good.  I have ran execution of some queries that took 10 minutes and when I changed WHERE and forced it to use the proper index took...

Even scarier is going home for whatever reason and running into your friends that you remember as thin with ahir and finding a fat bald man with bad teeth and...

Nick,

Look at the CONVERT function.  I prefer the following to strip TIME:  CONVERT(VARCHAR(10), GETDATE(), 101)

Steve is right.  Depending on how you want it ordered you may want to consider JOINING a 2nd table on this field and then ORDER BY a numeric in the...

I would use the destination server for a couple of different reasons (which may or may not be correct)

1. IF this is to only be used by your application why muddy...

Something we do is have a tracking table that every DTS package writes to that contains their start/end and SPID for cross reference purposes.  We also use that table for...

Ah yes, the IT department is fashionable 1x every 20 - 30 years and WE get the shaft.....

How bout?

DECLARE @Date      DATETIME

DECLARE @StartDate DATETIME

DECLARE @EndDate   DATETIME

DECLARE @Loop      INTEGER

DECLARE @Cnt       INTEGER

SET @Loop      = 1

SET @Cnt       = 1

SET @StartDate = '2004-11-20'

SET @EndDate   = '2004-11-30'

SET @Loop      = DATEDIFF(DAY, @StartDate, @EndDate)

SET @Date     ...