Thanks but I stil lthink its wrong/misleading and can hide errors.

The factorial example works as I would expect it to. Its procedural code working on variables. Just doing a one...

mark - you are 100% on track.

I know remember this .net stuff has an extra DB I had to create the tables for someone once.

So if you were going to...

Thank you v.much

Its these little bits of info that always scupper you when you come to it.

Thanks Mark, I would like another website but I'm not a web developer.

Anthony I will be using the AD stuff as it will sit on our Network. I hope...

Thank you v.much

Got the audit set up and running not the format I wanted will try the capture event. As usual something has come up so will have to drop...

Thanks

Not used try catch before

Guess it will look something like this

Try -- move rec from tblCustomer_deleted --> tblCustomer

(

set identity_insert tblCustomer on

Begin Trans

insert into tblCustomer

...

Thanks

But your idea is a good one, something I'm going to file away.

I've just written the SP that generates the view.

Its just any view that calls it must be...

You are correct, this is really formatting so should be done by data presenter.

The reporting software is Excel. the people using do not have the skills (neither do I or...

Thanks Jason. I could do this becuase for every svcname there is a contious SVCID which is an Identity field. So I could add say 10 onto the last svcid...

Thanks - oops my fault I was indeed updating whole table my where clause was nonsense.

Works for me, but I had to make the trigger on the base table doesn't support after trigger on view.

One thing I did notice; I issued an update that would...

Mr Magoo (love the name by the way!!)

I didn't know you could roll back in an after trigger - I thought the change had been committed already.

will not be able to post for next 3 days - Not been rude 🙂

Both DBs simple recovery model

Thanks will do transaction..