It's possible that this is down to the ANSI options the query is executed with. Not sure how you influence these in SSIS, but you can change them in SSMS...

Or... do the rollback as part of the error handling for each step:-

DECLARE @ERR BIT

SET @ERR = 0

BEGIN TRAN

-- run first proc

EXEC @Result...

I think you also need to add complexity into the mix.

Managing a large number of servers that do nothing but respond to client applications is comparatively easy.

Add replication, clustering, database...

Trooper (9/11/2009)

---

In my case the full backup failed yesterdy night and I had the full backup taken this morning.....

So will I not be able to restored the transactional log backups...

Forgot to also mention... switching to simple mode stops your ability to restore transaction logs beyond that point. So any user changes between that point and when you take your...

Chage the sequence a...

Silverfox (9/11/2009)

You can take Paul suggestion, which is a good one, for 8GB allocate 6GB. which is roughly about 75% of the total server memory. on a 16GB box, I...

Not as good as the UK ones, I can see their...

If you search this forum or Google/Bing, you will find no end of sob stories where people have tried to backup over a network, only to have it fail. The...

Have I missed something here... your original post says

Yet later on you say

with 16...

Paul and Silverfox are correct.

Yes

nchar(1) allows SQL Server to store 1 unicode character.

A byte is 8 bits long (allowing 256 different combinations). Unicode allows you to store 65000 different combinations, which takes 2...

Which table do you want to delete from... the original or the archive?

What data do you want to delete... all of it, or just rows matching the data being inserted?

Your trigger doesn't refer to the INSERTED table, but refers to the base table (Tab) instead.

It's therefore possible for it to pick up data already in the table, even if...