a new system table sys.sql_expression_dependencies , very helpful in find the objects referring in other databases.
| use <databasename> SELECT OBJECT_NAME (referencing_id),referenced_database_name, |
Subscribe to:
Post Comments (Atom)
Featured Post
SQL Server AWS Migration BCP
stored procedure to generate BCP scritps to migrate the SQL Server database. Developed this stored procedure on my labs to simulate t...
-
query execution in the production taking long time one of the query in the production taking almost 40 minutes instead seconds where it us...
-
SQL Server Data Masking : Download code DataMasking.sql Masking data can be done through updating the confidential information in t...
-
Pivot without Aggregating with consistent and inconsistent formats: One of the most common tasks which I came across at least once in almo...
No comments:
Post a Comment