How to verify temporary tables on the sql server.

(0) Share

Report

Posted on by pops67

815

Hi Experts,

I couldn't find any other temporary tables on the sql server in D365FO referring to URL as below,

Difference between InMemory and TempDB tables in D365 F&O – Dynamics 365 Finance & Operations (14-dynamics365.com)

Is it possible to see the data of temporary tables using ssms?

Could anyone tell me It's possible to verify and see data of temporary table to have table type is TempDB?

Otherwise, Is it difficult to see data of temporary tables on the sql server? Actually, I have never seen temporary tables on AXDB.

Thanks in advance.

I have the same question (0)

All responses (5)

Answers (0)

WillWU 22,361 on at

Like (0)

Report
Hi Mitsugo Nakamura,

If you are on the tier1 environment please try to set the value for TEMPTABLEINAXDB to 1 in the SysGlobalConfiguration table.

update SysGlobalConfiguration set value=1 where name ='TEMPTABLEINAXDB'

Refer to: www.linkedin.com/.../how-tempdb-tables-implemented-msdyn365fo-paul-heisterkamp

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

Hi Mitsugo,

could you tell us what you are trying to achieve?

Was this reply helpful? Yes No
pops67 815 on at

Like (0)

Report

Hi Will,

Thank you so much for your kind reply but I'm struggling against this issue that I can't see and find temporary table in tempdb yet. although I updated

SysGlobalConfiguration as you told me.

p.s: Sorry for the late reply

Best regards

Was this reply helpful? Yes No
pops67 815 on at

Like (0)

Report

Hi Nikolaos,

Sorry for the late reply.

A few days ago I came across this url-14-dynamics365.com/.../ and then I would like to verify about TempDB of temporary table on the SQL Server in D365FO.

As Will mentioned above reply, I found the place of temporary table on SQL server but I struggling to find temporary table that I have tested.

What I want thing is to find temporary table with property is TempDB before deleting on the SQL Server.

Would you please let me know how to find or make sure temporary table on DB?

Best regards,

Was this reply helpful? Yes No
Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report

Could you elaborate your problem, please?

Is it that you can't access TempDB for some reason, you don't see any tables, you don't know how to determine which table in TempTB is for your remporary buffer in AX, or what?

Was this reply helpful? Yes No