SqlDbx Forum

SqlDbx

You are not logged in.

#1 2020-11-09 12:21:06

ptoniolo
Member

Object dependencies, incorrect results in Azure

Object dependencies in Table/View/... Properties, when used in an Azure SQL Server databases is always empty.

I believe this is because SQLDbx uses the obsolete view sys.sql_dependencies. That view returns incorrect results in the new versions of sql databases.
SQLDbx shoud call the sys.sql_expression_dependencies instead. The new view returns the correct information, even in the Azure edition of SQL Server.

I am using SqlDbx 6.02 Pro 64 bit

Offline

Board footer

Powered by FluxBB