checkmk
checkmk copied to clipboard
Replace system table query with system catalog views query
General information
You should not code Transact-SQL statements that directly query the system tables, unless that is the only way to obtain the information that is required by the application. Instead, applications should obtain catalog and system information by using the following:
- System catalog views
- SQL-SMO
- Windows Management Instrumentation (WMI) interface
- Catalog functions, methods, attributes, or properties of the data API used in the application, such as ADO, OLE DB, or ODBC.
- Transact-SQL system stored procedures and built-in functions.
Proposed changes
As specified in the Microsoft documentation I replaced the direct query on the system tables with the appropriate view
- What is the expected behavior? Exactly like before
- What is the observed behavior? Exactly like before
- If it's not obvious from the above: In what way does your patch change the current behavior? Replace system table query with System catalog views query
I have read the CLA Document and I hereby sign the CLA or my organization already has a signed CLA.