Hi Vladen,

You're right its not an ideal way to write a trigger, and it only worked because I knew the way the application code would have updated the table. ...

Ermm .. you caught me out there - as a Brit I have no idea what Thanksgiving is - did it ever have a Christian church trying to ban...

You could SELECT the contents to another local table variable, and modify that. ...

Steve only does 10-pointers for Pagan festivals, Like Halloween and Yuletide 😀

It may take me a while. I'm starting from scratch with the CLR.

:w00t::w00t::w00t:

The one by Derek Comingore and Douglas Hinson!

By amazingly stupendous coincidence I have that book - I've had it (unopened :blush: ) for over a year now. Thanks for...

I've got a bit of spare time these days - I'm doing this Fortran replacement thing between the itty bitty niggley things that crop up.

I've not looked at the CLR...

Yes you never know if the question wants totally exact answers (as some do) - or not - as in this case where WHEN NOT MATCHED BY SOURCE is the...

Good article Manie.

This forum was my first experience of online forums and I am grateful for the help I get.

Because of the positive experience here I've joined forums...

Trick question!

- how about some recognition for getting it partly right?

You need to find another way to get your data back. The LDF file alone will not work.

Either an older backup if you have one or, if its a...

No - in any practical situation this would be impossible

I've gone for simplicity, and abandoned any attempt at making sense of the data's internal structure. Its just a Block of float values this way

CREATE TABLE BlockRef (

pKey...

Could it be worth trying N before your quoted string

WHERE col1 = N'chinese chars'

Hi Jeff

I really appreciate you looking at this. Posting this makes me think more about what I'm doing, and your replies meant I had to ask the user some...