If you have deeply nested XML documents (or json, html, sql) with recursive nodes (node 'folder' in node 'folder' in node 'folder') of a mixed complex type without an XSD/DTD...

This doesn't search in the complete database.

It walks through the .dbo schema only. If the tables are in another schema, the script fails.

Shouldn't you use

Declare @Schema_Selected varchar(50)

set...