Hi Beatrix,

Yes, indeed I have, which...

Cheers Chris! Interest link too! Thanks.

Brilliant, thanks Kevin!

Aye. Well, ive been experimenting.

If I set the Transaction Option to 'required' rather than supported, I get an error about being unable to start a distributed transaction.

Edit: This is on...

I've double confirmed that is the case using oledb provider as well as ado.net.

It's annoying!

Hiya, thanks! I like this approach of using the delete/output as an SSIS Source.

However.

I am using the ADO.NET provider. And it's working fine, except in one particular occurrence: Should I...

Morning 🙂

I was in no way offended, but I did want to clarify what my question asking.

Interesting point on white space in compressed backups behaving different to non-compressed -- I...

Not...

Ah! Marvellous, cheers Eric.

Hi Eric,

Whilst it is not a heap, there is a clustered index on a datetime field, I am curious as to how one would go about reclaiming the space if...

Thanks all for your replies.

Yes, I can appreciate the size of the file must remain the same, in line with your library shelf analogy. However, I expected to see free...