The cause of this problem is people with nothing better to do than deface others' property.

It's a SQL Injection issue. You need to make sure you are not allowing SQL...

What are the errors?

A few things to check:

- Are the files written correctly to the different folders? Meaning they look like the correct log backups from the source systems

-...

Most software, or services, cost some decent $$. If you can get by with less features, OSTRESS (http://support.microsoft.com/kb/887057) might owrk for you.

In T-SQL, you'd have to import the data into a table.

In SSIS, there might be a way, but you'd have to read the text file and check each row for...

Naming conflict somewhere? maybe with the job names? I assume the dbs are differently named?

I'll add in, what is the amount of data you can lose? Or can deal with a loss? how quickly do you need to recover?

I use diffs to keep daily,...

I'd agree that you want to do it in both places. However, I'd load the validation domains, list of choices, from the db into the middle layer. Find a way...

Usually you do not want to do things in a looping manner in SQL Server. The db engine is optimized to do things with sets of data.

If you don't know...

Can you post the DDL for both tables? Basically you'd

insert Destination (col1, col2, col3, col4)

select col1, col2, default_for_3, default_for_4

from SourceTable

It's hard to say what you should do. Is the data needed there?

You have 2 choices.

1. Put the columns that are in the source in the list and then use...

If you feel someone using the product is good enough, then that's your opinion. You shouldn't push that on others, or assume that other software developers feel the same way....

Yes, but be sure this is what you want. In a FK, you have to remove all children before you can remove a parent. Note that you might have multiple...

The queries will not likely have memory leaks. You're using basic SQL that has been exhaustively tested. I guess it's possible, but I haven't seen it in years of doing...

Open Source != free. It means that someone is allowing you to see how the code works.

Lots of these little utilities are written by someone that does it in their...

You are trying to delete rows that have a FK reference. You need to delete the child rows before you can remove the parent.