I agree that SQL doesn't lock up for no reason. I've never seen this before in my 8 years with SQL server. I'm lucky in that there are...

Nothing in the event log, nothing on the console. The system just suddenly stops accepting new connections.

Well it's an indexed scan... as opposed to a table... so I can accept that...

I have no scan predicates, just objects... logindomain, login and logout times... :/ created...

Actually I'm using a slightly different query

select * from (

select

logindomain,

max_login = max(logins)

from (

select

a.logindomain,

b.timeentry,

logins = count(*)

from

user_logins a join #times_list b on

b.timeentry between a.userlogin and a.userlogout

group by

b.timeentry,

a.logindomain

) main

group by

main.logindomain

) a...

oddly enough I get the reverse... I get a seek on the times table... and a scan on the logins... hmmm

Actually that was after indexing both tables

I created the time table as just a list of 1 minute entries and indexed that. I indexed the logins table both...

Thanks! I was trying to think of a set/relation method to make it work instead of the cumbersome loop... 43 seconds for this stage for a week's worth of...

I found two in the scripts listings here. One works great on SQL 2k5, the other for 2k. I modified them to accept the database to store the...

Works great when you have one to open... some of us have made job transitions to SQL 2k5 only shops... :/

I have to agree... Things I used to know how to do in DTS I find to be a major chore in SSIS. I miss DTS... Would have been...

Well I hope somebody has an idea...

Here's my latest attempt. I figured that since I had a single data flow set (Datareader -> SQl Server) that was actually...

Bit more information if it can help.

I used DataReader Sources in my Data Flow portion. I had to do this as the data is coming from an ODBC connection...

Full Test Indexes are great when you want to cram for finals in college... didn't know that SQL server maintained them though.