Here.  Thanks

Thank you for the so-fast reply : ).

Can you tell me how I check my connection pool setting?

I'm talking about timeout in the database setup in analysis services and not about a query timeout.   About analysis services says it is version 8.0.760 (runs on Windows 2000, Version 5.0.2195...

We can't change the data model at this point ... I inherited it and in all fairness to my predicessor hind sight is 20/20... age is where age is. ...

Thanks ! for the info.  I'll pass anything I learn new along here.

So this is what I should run?  If when Mary Jane was 18 and 19 she made not-so-nice phone calls don't I get 2 records for her...

I dont' need a begin tran or end tran?

Question #2: 

Age is the age of the person and it is in the file so should not be computed.

There is no date...

Question 1:  Will the 'Select TOP 1.... / order by Calldate' only work if I'm checking on only 1 not-so-nice caller?  I don't just want mary janes last not-so-nice call ... I...

I'm going to look all this stuff over.   Have you implemented such a solution?  

We're checking on credentials now and trying the CNU fix.  I'll let you know how it goes

Thanks

Don't drive faster than your guardian angel...

Servers setup for Mixed.

Auth through Windows

-is the user mjane a domian account ?? Local

-is the account domain\mjane a user in the sql security and assigned to some database?? Yes

-how is the users connecting, QA, isql, etc ?  ...

Thanks to everyone for responding.  Two more questions ... will syscomments work if comments were not saved?  Will this solution capture DTS, Stored PRocedure, Trigger, and UDF impacts?

Thanks Again, : )...

The log in the package properties was fine, however, I did find an invalid path for the log in the task.

Thanks!