I'm trying to update an ID field that is set as an identifying field. I tried using the query below, but get an error that says,"cannot update identity column 'ID' Can someone help me with this?
SET IDENTITY_INSERT [prospects] OFF
set ID = 145191
where id = 145540