How can we help you today? How can we help you today?

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?
nharris18
0

Comments

1 comment

Sort by
  • DanC
    Hi @nharris18

    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.
    DanC
    0

Add comment

Please sign in to leave a comment.