Thanks Allen,

Also I could see the SQL being executed by the session from the current activity in the Enterprrise manager by clicking on the session .

Does SQL server rollback one of the transactions if there is a dead lock ? ( Oracle does ) . Anyway I killed the blocking sessions and it runs fine.

Thanks

- Jay