Thanks Eirikur  and Phil.

In some institutions sql devs and dba's are geographically dispersed.
Devs may not be aware of the sudden changes by DBA's in Server configuration...

Thanks again John. It worked!

SET NOCOUNT ON
DECLARE @stringToFind VARCHAR(100)
DECLARE @stringReplacement VARCHAR(100)
DECLARE @schema sysname
DECLARE @table sysname
DECLARE @count INT...

Thanks John for your generous suggestions. The script that I have been working on will be used for migration of @email1.com to @email2.com of about 200 to 300 accounts.

If the loop within the loop is done, should the string pairs be contained in array or tempdb?