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...

You need an IF statement.

If x = 1

select y, z from my table

else

select y, z, from table2

You cannot change the from statement with a case.

Interesting, and I thought objectname was broken as a filter. Thanks for the info, scott.

It's highly frowned upon and could cause problems. In SQL Server 7, triggers on system tables were not guarenteed to fire.

I'd setup a job that runs every hour to look...

The app might have been an admin on the nondedicated machine and you were not aware of it. Being an admin and named pipes v TCP should not have anything...