Greg has the three ways to do this. #1 is the quickest way in a disaster, but #3 makes more sense since packages become corrupt and you wouldn't want to...

I heard this in a NetIQ lecture a couple years ago as well. There are two things at work. One is the fragmentation problems as well as the greater likelihood...

Age and treachery will always defeat youth and exuberance.

It would be nice to see photos, but not everyone wants that. Many people don't want to be recognized, so we don't...

Not sure, might try http://www.justsqlserverjobs.com/. I'd guess you're less expensive than Denver. I'd say avg $70-75k here.

http://www.microsoft.com/sql/2005/

No good one I know of. There are some white papers here (http://www.microsoft.com/sql/2005/) and lots of Webcasts this week from Microsoft (see http://www.databasedaily.com)

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