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?

Have you tried CSTR()?

CSV has it as just text, the driver may see it differently, but from a text file, I'm not sure CAST or CONVERT work. I'd deal with...

There are a few utilities as well that can help here. We had a press release about SQL Digger last week, which does searching.

You can put them all in one transaction, but you could generate a huge log on the alters as many of them are rename table, create new table, load data.

I'd...

There must be some sort of job or process that is running. Or someone is manually executing the jobs. You could run profiler and trap just those backup events. That...

The log is used just like a database log. It stores information about the transactions that are in use. Since there isn't really a recovery when you restart, the tempdb...

Agree with Brian that this is confusing. Does the existing software run on SQL Server, but you want a second database? Or is it running on other database software?

I've had...

http://www.homepower.com/index.cfm

http://www.homesteadtechnology.com/power/

Sorry, it's not a choice. Those are good points, but the intention is to see if you know which tool to use. Launching EM is a bit of a giveaway...