Getting error when dataverse connecting through MS SQL SERVER 2022

[UBdev]

HI, I am getting error message

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

"Invalid column name 'is_dropped_ledger_column'."
RequestId: TDS;1e3443e5-c370-40a1-98a6-043ec6d6cdd7;10
Time: 2023-04-07T05:51:35.1090605Z (Microsoft SQL Server, Error: 40000)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-40000-database-engine-...

If you anyone have answer. Please help me.

Thanks

[#2]

@UBdev 

This isn't really the correct place to ask about the Dataverse.

While you can access the Dataverse via the TDS endpoint, SQL Server and the Dataverse are still very different beasts.

As to the error itself, there's no way we can help you with this one other than to say that it's probably quite correct.

Perhaps run a simple "SELECT TOP 1 * FROM [yourDataverseTableName]" and verify that you haven't made a spelling error with that column name.

Otherwise, you'd have to leverage another approach such as using the Dataverse REST calls or the Power Platform's native environment explorer to try and confirm where the discrepancy lies.

Cheers,

Lain