Answer to my own question

ALTER TRIGGER [trgPreventDeletion]

ON [dbo].[AUDITACCESS]

AFTER DELETE

AS

IF (SELECT COUNT(*) FROM DELETED) > 1

BEGIN

RAISERROR ('Audit access entries cannot be deleted', 16, 10) WITH LOG

ROLLBACK TRANSACTION;

END

Is this ok seems...

Answer to my own question yes it does.

Hi Markus

Thanks for that what, if i created a new table would that be mirrored.

Thanks

Gary

Sorry should have mentioned that i wanted to use this for a mirror.

I have just created the mirror and it has worked how i wanted

thanks

Hi No i wanted to change the service id value to ATAS for all with the results from the query

Answer to my own question used

Select DISTINCT SSOUsers_RowID,FamilyType,'ATAS',Param1,Param2,param3,param4

did work must have had a typo previously

Hi That worked great,

I forgot that i need to also put where Table1.AccRv='RM'

Table1.AccRv this is another column in the table that i left out of the original code.

Can this be...