I'm getting this error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #398) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
/export_to_excel.asp, line 18
I have an ASP page that goes against SQL Server 7.0.
It runs a stored proc and returns the result into the page. The page works sometimes and the other times it brings back the above error.
Also I have the feature on the page to export the result to excel and it's giving me the same problem.