Untitled

mail@pastecode.io avatar
unknown
plain_text
2 months ago
467 B
4
Indexable
Never
ADGroups might have a different name or reside in a different schema / be a synonym, let's run a check for the table across all schemas and possible synonyms in the database:

EXEC ('USE CIMA_ACCOUNTING; 
       SELECT schema_name(schema_id) AS schema_name, name 
       FROM sys.objects 
       WHERE name LIKE ''%ADGroups%'' AND type = ''U''; 
       SELECT name, base_object_name 
       FROM sys.synonyms 
       WHERE name LIKE ''%ADGroups%''') AT cima_aws_dev;
Leave a Comment