News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... DevBox - SQL Query sho...

Finance | Project Operations, Human Resources, ...

Suggested answer

DevBox - SQL Query show the table but not the data

(3) Share

Report

Report

Posted on by SyrusBauzigur

95

I have cloned my TestBox to a Devbox via LCS
I have everything and accessing the VM along with admin credentials, all works well
When I login from front end (D365), I see all the data in the tables
When I run SSMS, it shows the table but no data

What am I missing?

Categories:

Dynamics 365 Finance

All responses Img

All responses (4)

Answers Img

Answers (0)

Martin Dráb 230,655 Most Valuable Professional on at

Like (0)

Report

DevBox - SQL Query show the table but not the data

Moved from Integration, Dataverse, and general topics forum.
Suggested answer

Jonas "Jones" Melgaard 2,146 on at

Like (0)

Report

DevBox - SQL Query show the table but not the data

Yep, you are selecting from the wrong schema.

The ax.* tables are reserved for Commerce / Retail. You need to use the tables that start with DBO.

Like this:
SyrusBauzigur 95 on at

Like (0)

Report

DevBox - SQL Query show the table but not the data

Please see below. Views also turn blank
Jonas "Jones" Melgaard 2,146 on at

Like (0)

Report

DevBox - SQL Query show the table but not the data

What schema are you selecting from?

Is it like this: [dbo].[InventTrans]

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,938 Super User 2024 Season 2

#2

Martin Dráb 230,655 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans