Test the process from QA, loggin in as that user. Then execute everythign your page will execute.

Or something in the package that causes a fatal error. Do you know when it fails? Add in logging in the package maybe to see when it fails?

I thought there was a kb article on how to restore these, but I can't seem to find it. If anyone does, a link would be appreciated.

I don't want to comment on the article or SSWUG, but they are not a user group. They are a for profit business.

You must have changed a default somewhere. What tasks/connections are in your package? What types of connections are you making?

If you are selecting all or most of the data from the table, the indexes don't help because a scan will occur. Chcejing fragmentation often can speed this up.

I...

I'm always wary of putting a hard coded password in the application. better to store it outside, registry, file, something and encrypt that somehow so it can be changed.

Definately don't...

Please don't cross post. all forums are covered.

Answered in other post.

I've seen this sometimes with strange data coming back, like something corrupts the TDS stream. Can you do a select * from each of the tables, which might narrow down...

That should work. Be sure you add a WHERE clause based on your criteria.

When you login as sa, thre is no NTUsername, that's when you log in using Windows authentication.

I agree with AJ, change the pwd and you'll find out, or someone will...

You might have to write some ASP or VB code to get it to display. I suspect the textbox thing in QA is limited here for some reason.

the checkpoint should occur every minute or so. Are you sure of the recovery model? Also, dbcc opentran, there might be an open transaction which is causing it to grow.

If your website is for authenticated people in your company, you'd use CALs. If it's the internet and anonymous people, it's per CPU.

You can check syslogins for the last change date. This is for any aspect of the login, not just passwords, but in reality, it usually is the password that is...