checkmk icon indicating copy to clipboard operation
checkmk copied to clipboard

Replace system table query with system catalog views query

Open fabiozanella opened this issue 2 years ago • 0 comments

General information

From Microsoft documentation:

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.

fabiozanella avatar Dec 05 '23 11:12 fabiozanella