SET NOCOUNT ON UPDATE CDR SET #_arrayColumn# = , lastUpdated = { fn now() } FROM tbl_BRETT_Test CDR WHERE CDR.ownerId = 36 AND CDR.ownerType = 'BRO' SELECT changedRows = @@ROWCOUNT SET NOCOUNT OFF