I know how to write the SQL and have ONLY SQL access to the DB (via Linked server), but I'm looking for a way to get a list of all the tables dynamically and search all fields. I can do this with regular SQL DB, but not linked server (that I'm aware of)