You should have a few cases in a test that you can use to verify this works for all cases. That's what I'd do for this type of query where...

ms_foreachdb

https://www.mssqltips.com/sqlservertip/1414/run-same-command-on-all-sql-server-databases-without-cursors/

It might. The FTS engine got a lot of work in 2005/2008. Not a lot since.

Sorry, I think I left something out.

You need to programmatically:
1.  change the pwd in AD
2. change the pwd for the local service(s)

Both need to...

The Config Manager is nothing magic. You don't need to use this to set a SQL Server service account. Config manager sets
- the service properties as you would...

You must use the share path defined in Config Manager. You CANNOT use a physical path.

OK, sorry, haven't had a chance to test this, but the data can't be inserted into the temp table when encrypted. That makes sense, given the nature of this encryption....

You're attacking the problem in the wrong way. we want everything to be embedded. For example, I could do this:

select *
 from table
where  column in...

You need to either convince the auditors that these don't need to be changed (good luck) or change them. We used to have a script that would alter passwords on...

When you say you use lots of temp tables, are you querying/filtering on the columns that need AE? If I had

create table CUstomer
(CustomerName varchar.

I don't. been a long time since I've used the DTS system at any scale, and haven't tracked the rows here. I'll try to set up a test and see...

This article (http://www.sqlservercentral.com/articles/Agent+jobs/101563/) might be of interest.

You can get some information from here: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-fts-index-population-transact-sql
However, I'm not sure this will do more than give you an idea of how many more items need to...

Yes, lots of articles on different parts of basics stats.