Description
The error is:
"Failed to list jobs due to error (pytds.tds_base.ProgrammingError) ("\u5bf9\u8c61\u540d 'sys.sql_expression_dependencies' \u65e0\u6548\u3002", None)\n[SQL: \n SELECT DISTINCT\n coalesce(lower(referenced_database_name), db_name()) AS db,\n referenced_schema_name AS [schema],\n referenced_entity_name AS [name],\n o1.type_desc AS [type]\n FROM sys.sql_expression_dependencies AS sed\n INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id\n left join sys.objects o1 on sed.referenced_id = o1.object_id\n WHERE referencing_id = OBJECT_ID(N'xxx')\n AND referenced_schema_name is not null\n AND o1.type_desc in ('TABLE_TYPE', 'VIEW', 'SQL_STORED_PROCEDURE', 'USER_TABLE')\n ]\n(Background on this error at: https://sqlalche.me/e/14/f405)"
SQL server2008 is an old version that does not include sys.sql_expression_dependencies,so I cannot execute it:
USE 'DATA_DB_NAME'
GRANT VIEW DEFINITION TO 'USERNAME'
GRANT SELECT ON OBJECT::sys.sql_expression_dependencies TO 'USERNAME'
This is an old project and I dare not upgrade. What should I do?
Requesting help, thank you very much
Activity