Retour
-
Titre
"Parse error: [Incorrect syntax near 'Connection'] at [position: 3018, line: 99, column: 77]" error appears when trying to link a database in any source control system -
Description
Repro steps:
- Create a database
- With the attached SQL procedure create a storage procedure [documentation].[SprocGetWorkflowCategorySQLObjects]
- link a database in for example dedicated Git source control system
- The Action Center will open with the following message "Database and source control are synced", although the mentioned procedure isn't linked and does not exist on the repository
Expected:
The user should be able to link the attached stored procedure to a Git repository without any issues. -
Résolution
Workaround:
In the Stored procedure at lines: 102 and 103 in front of [column_alias] the AS should be added.
(cast(ta.fldproperties.query('data(//*:CommandText)') as nvarchar(max))) AS ObjectName,
(cast(ta.fldproperties.query('data(//*:ConnectionName)') as nvarchar(max))) AS Connection,
With this workaround, the stored procedure is parsed correctly and is shown in the Action Center.
-
Identifiant du défaut
229878