• You need to figure out what is blocking the command. You can use the system_health session in SQL Server 2008 to pull the deadlock XML[/url].

    From there you have to determine what process is causing the deadlock and adjust for it. If your users are executing actual T-SQL frequently they should build their queries to workaround or detect for deadlock errors.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton