problem versioning stored procedure that use temporal table
dreammaster83
Posts: 3
we are trying to use sql source control 5 on a 2016 db.
we are using system versioned temporal table, sql source control gives me an error on stored procedure and user functions that use fot system_time (error parsing file).
for example:
source control let me commit the sp but after that when it try the find modified objects it throws the error.
How can i solve this problem?
we are using system versioned temporal table, sql source control gives me an error on stored procedure and user functions that use fot system_time (error parsing file).
for example:
select * from dbo.ADDETTI_STRUTTURE_VAL ast LEFT OUTER JOIN (SELECT * FROM dbo.IMPIEGHI_VAL FOR SYSTEM_TIME AS OF @reference_date_dt2 where COD_SOCIETA = @cod_societa) im ON im.COD_IMPIEGO = ast.COD_IMPIEGO
source control let me commit the sp but after that when it try the find modified objects it throws the error.
How can i solve this problem?
Comments
What is the full version number of SQL Source Control you are using?
A support ticket has been created for you: https://redgatesupport.zendesk.com/agent/tickets/81769
Would you please locate the SQL Source Control log file from the period this error occurred? You will find the log files in this path:
C:Users<user_name>AppDataLocalRed GateLogsSQL Source Control
Please attach a copy of the log file to your support ticket or email support@red-gate.com quoting your call reference #81769, with a copy of the log file attached for us to review.
Many thanks,
Rob
Red Gate
unfortunately today we have again the same problem with this user function:
i'll attach my log file to the ticket.