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

I think he's referring to the US missing the Olympics last year. That's despite winning in 2000.

It was great, Rockies down 2 in...

Errrrrrr.

You can run SQL Server on Windows on Linux.

I wish they'd port it.

And I thought no one would fooled. I actually wrote 3 different ones and Andy and Brian liked this one the best, so thank them. You could have been reading...