Will do. Thanks for the help.

"Could not load type 'Microsoft.SqlServer.Management.SqlManagerUI.DisableTrigger' from Assembly 'Microsoft.SqlServer.Express.SqlManagerUI, Version=9.0.242.0, Culture=neutral, PublicKeyToken =......."

I tried to disable it, and it wouldn't let me.

Aha! It was a trigger - there was a trigger on that table that was set up to track changes to the table.

I scripted out...

I did run the select first to make sure I had the field names correct, and it returned a specific number of records, then I ran the update, and it...