I'm really close to getting this, just need to get the appointment_date_time in the return values, if I add it in, it says it needs to be in an aggregate...

This is what I come up with, but its not right.  Its only removing about 30 rows, and still has multiple instances of the appointments

SELECT dbo.Appointment_Date_Time.Appointment_Log_ID,

           dbo.Appointment_Date_Time.Appointment_Date_Time,

           MAX(dbo.Appointment_Date_Time.Data_Entry_Time_Stamp)

FROM   dbo.Appointment_Date_Time

GROUP BY    dbo.Appointment_Date_Time.Appointment_Log_ID,

          ...

First things first....this database is on a webhosts server, therefor I do not have full permissions myself.

I get an error when trying to create a new login (I do not...

Yes it was set in Single User mode   

Problem is, I do not have the rights to change it myself, and the tech...

yes it is responding, its only when the query gets large that it times out.  it is a dynamic query that can have nothing in the where, or several hundred...

The exact exception message is "Cannot open database requested in login '<databasename>'.

Login fails."

<databasename> being the actual name

I'm gonna check on the single user mode, I can't get my EM...