Please provide test scripts to include this testcase for testing.

now i get below exception because the query for extraction is failing

---

@ivan,

I've analysed the script provided here  by @tariq and it is observed that the query contains two adjacent AND keywords as:

---

This is occurring due the following code snippet in ExtractDependency#getReferencedObjectsList()at line#1661&1662.

if (SQLServer2012orGreater) { // 2012+

   // uddts
   sql.append("SELECT schema_name(t.schema_id), t.name, 'UDDT' type ");
   sql.append("FROM sys.sequences s LEFT JOIN sys.types t ON s.system_type_id = t.system_type_id AND s.user_type_id = t.user_type_id ");
   sql.append("WHERE s.system_type_id != s.user_type_id AND ");
   sql.append("AND s.name = N'").append(ConnectionContext.escapeQuotes(name)).append("' AND schema_name(s.schema_id) = N'").append(ConnectionContext.escapeQuotes(schema)).append("'");
}

where we are using the two adjacent AND keywords. We need to remove one of those.

Thank you pradipjare.  Looks to have been a syntax error when initial extract dependencies where created.  removed one of the "AND" from the syntax and now works correctly.

Commit Revision 50725

Verified issue in ADS18.0.0-dev-253

No exception occurs,after clicking objects from schema compare window.