Hi

Yes, it is a major product from Microsoft, it is their ERP system Dynamics AX.  There is no way that the product (database) has data integrity issues as suggested in...

• This reply was modified 5 years, 3 months ago by  Gamleur84.

Hi

Thank you for all the responses.

It is correct to say the database was created by some form of "code first" method where the application generates the tables. Actually, the schema...

Thanks

Looks like the option to mark your reply as the answer is gone.

hi,

So it is possible that a lock escalation happens on a small table ? I thought lock escalation was essentially to prevent high memory consumption from many locks on big...

Hi

I think you understood my case correctly. So you believe the only way to achieve that is create and SP or create and run a scheduled SQL job ?

Thank you

Hi,

Maybe you could check the Report Server ExecutionLog ?

https://docs.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view?view=sql-server-2017

I can see the following field:

March 28, 2019 at 6:59 pm

#2034160