My requirement is when ever any insert|update|delete happens on Table1:Test,

then it should check the ID value in table SID, if ID is avaiale then update the column "status" to Y

can u please help in providing the query...