SA0253 : The current database is hardcoded in object reference
The topic describes the SA0253 analysis rule.
The current database is hardcoded in object reference
The rule looks inside SELECT, UPDATE, DELETE, INSERT, MERGE and EXECUTE statements for object qualified with current database.
Avoid four part identifier names with hardcoded references to the current database.
This way using hardcoded current database name, could later cause maintainability problems as for example if the code is used in another database or the database name is changed.
The rule has a Batch scope and is applied only on the SQL script.
Rule has no parameters.
The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.
Design Rules, New Rules
There is no additional info for this rule.
1EXECUTE database1.schema1.proc1 2EXECUTE adventureWorks2008r2_test.schema1.proc1
|1||SA0253 : The current database is hardcoded in object reference.||2||8|
© Ubitsoft Ltd. All Rights Reserved.