Cannot catalog stored procedures for updating temporal columns in advance - by Greg Low - Australia

Status : 

 


12
0
Sign in
to vote
ID 2500716 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 3/21/2016 11:17:24 PM
Access Restriction Public

Description

I have a stored procedure that removes the temporal nature of a table so that I can update the history directly.
I cannot catalog a stored procedure that is intended for use only when the temporal nature is removed. 
When I try to catalog it, the error Msg 13537 Cannot update GENERATED ALWAYS columns in table is returned.
This is not appropriate as I am not trying to update the table, only to catalog the procedure that will update the table later. It will run when the table is not temporal.
Sign in to post a comment.