Return
-
Title
"Parse error: [ ,CONVERT(DATETIME , cast( [Start Time] as datetime)" error is encountered when trying to link a database on the Git repository -
Description
Steps to reproduce the issue:
- create a new database
- execute the attached stored procedure
- link a newly created database to a Git repository in shared development model
- after finishing the link process the following message will be presented: "Database and source control are synced. Click to refresh" although the Git repository is empty
- in the log files you will find the next error: Parse error: [Incorrect syntax near 'AT'] at [position: 2337, line: 85, column: 59]
Parse error: [ ,CONVERT(DATETIME , cast( [Start Time] as datetime) AT TIME ZONE 'GMT Standard Time' AT TIME ZONE 'UTC' ) as [Start Time]] at [position: 2337, line: 85, column: 59]
-
Resolution
WORKAROUND:
None
STATUS
Waiting for a fix in a future release of ApexSQL Source Control