Hello,
I have a grid application in which I have the option to export to Excel active. When I do a search that generates few records (1,000 or a little more), the excel file is generated without problem. But if I do a search that returns many records (eg 70,000) and then export it to excel, I get this message.SQLState: 40001 Error Code: 1205 Message: [Microsoft] [ODBC Driver 11 for SQL Server] [SQL Server] Transaction (Process ID 192) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Why does it generate it and how can I solve it?
Thank you,