why aren't use the table -nolock option.

its not applicable for delete option. but u can use it in application proc, when you are selecting records(select option).

i think its avoid the...

Hi ,

you doesn't need to join the main table (customer table).your expected result can get from second table(payment table). Is join the tables is mandatory?

Thanks vidhya.

Could you explain ,how to setting the trace in advance or

tell me about the ddl trigger.

Thanks Ken.