Hi,

The deadlocking is due to the application being designed around a single table and there are hundreds of connections to it. I tried giving the reporting guys a different box with an SSIS package that runs a couple of minutes before that gets the data transferred across from Production into the Reporting box. Tried to force a Query Governor limit to stop long running queries. But even then this continues. I can ask the Cluster Admin to increase the time if thats the only option. Any suggestion welcome.