Thanks Paul

CCB

Perfect.

Thanks guys.

Thanks Kenneth.

I have done this. Now my DW when viewed from Ent Manager says loading. I cannot get into it because it thinks it is in the middle of a...

Thanks for that Chris.

One final question.

If I want to only restore up to a certain point in the transaction log (examining my back shows I have 40 and I need...

Hi Chris, I tried that but I still get the same message.

Any chance you can show me the script with the names and paths I have outlined.

Thanks very much.

CCB

Thanks, I'll give that a go.

CCB

Hi,

That works a treat. I have changed the rest so that there is only one select statement.

Thanks for your help.

CCB

Hi Noel,

just tested that and it work perfectly.

Thanks and thanks to Steve too.

Regards

CCB

Hi Noeld,

Can you elaborate on this (set based DML) ?

Can I put it back into a cursor and set throught the changed records ?

Thanks

CCB

Fixed it, should be using is not null.

Trigger now looks as follows:

CREATE TRIGGER inspection_insert_parent_tree ON [dbo].[tblInspection]

FOR INSERT, UPDATE, DELETE

AS

DECLARE @ACT CHAR(6)

DECLARE @del BIT

DECLARE @ins BIT

SET...

The problem appears to be with the checks for nulls. If I remove them, the trigger fires correctly. Any suggestions anyone ?

Thanks CCB

Hi Steve,

I have a seperate one for update and delete, but point taken.

I wrapped it in a cursor in case more than one record is updated at once.

When I say...

Woops, sorry about that.

Thank you sushila.

CCB

Thanks Noel.

CCB

Hi Remi,

No I d'dn't know that.

What do you use ?