UPDATE ph SET
dnr = 0
FROM Phone ph
INNER JOIN Person p ON ph.PersonId = p.PersonId
WHERE
p.CompanyId = @CompanyId
Get's changed to
UPDATE [dbo].[ph] SET
dnr = 0
FROM [dbo].[Phone] ph
INNER JOIN [dbo].[Person] p ON ph.PersonId = p.PersonId
WHERE
p.CompanyId = @CompanyId
Which obvious causes a problem since [dbo].[ph] shouldn't have been qualified and left as an alias.
UPDATE ph SET dnr = 0 FROM Phone ph INNER JOIN Person p ON ph.PersonId = p.PersonId WHERE p.CompanyId = @CompanyIdGet's changed to
UPDATE [dbo].[ph] SET dnr = 0 FROM [dbo].[Phone] ph INNER JOIN [dbo].[Person] p ON ph.PersonId = p.PersonId WHERE p.CompanyId = @CompanyIdWhich obvious causes a problem since [dbo].[ph] shouldn't have been qualified and left as an alias.