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