Is this data compression inside the database? You could probably use any type of zip tool to compress data before you put it in, but it would make searching impossible.

The...

It's probably a link issue between the servers where one is too busy to respond quickly if it's not a consistent problem.

Brian,

Thanks. It happens sometimes as they update their filters and catch us for some reason.

I removed you.

No one sent me any comments

My mistake. Thinking of other languages. It's been corrected.

Maybe. It's an interesting concept. We have had a few people do reviews on their own, but for the most part, our authors don't. Perhaps we should call out the...

I do not think so. Profiler really helps here, but that requires SA access. There is an article on this site about tracing deadlocks.

http://www.sqlservercentral.com/columnists/skumar/tracingdeadlocks.asp

There are some third party development tools like those from Apex SQL, Embarcadero, and Imceda. Not sure how GIU they are.

Halo 2.

Rented it Sun night and my little boy is all into it. Was playing this morning before school!

The only way to do this is self join or use code from a front end tool.

select comb, cnta, cntb, cntc

from ( select comb, count(*) 'cnta'

...

All the DTS packages are stored in msdb, so if you backup msdb, the packages are there. If you want file version, you can save them as "structured Storage Files"...

Both of those require special privleges, which I normally don't give out.

Why do you need to work with a text file? Can you not store these values in a table?

On reboot, there should be a normal rollback/rollforward. Are you sure that there was a whole day of rollback?

If there was, then Markus' idea might be the best one to...

Does this work if you execute it in the DTS Designer?