Untitled

 avatar
unknown
plain_text
a year ago
467 B
8
Indexable
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;
Editor is loading...
Leave a Comment