Error thrown by SQL Doc in Azure DevOps build pipeline SQL Change Automation task
I have a SQL Change Automation task in an Azure DevOps build pipeline and have ticked the "Use Redgate Sql Doc" checkbox.
When it attempts to run, however, it throws the error "Reference to database and/or server name in 'master.sys.databases' is not supported in this version of SQL Server". Presumably, this is because of the limitations on cross-database queries in Azure SQL Database, so how do I set the component to run in the context of the target database?
When it attempts to run, however, it throws the error "Reference to database and/or server name in 'master.sys.databases' is not supported in this version of SQL Server". Presumably, this is because of the limitations on cross-database queries in Azure SQL Database, so how do I set the component to run in the context of the target database?
Answers
Sorry to hear you're experiencing this issue!
I'll need some more info from you such as verbose logs, so I'll reach out directly via a support ticket to avoid sending across sensitive information.
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?