SQL71508 - Problems with building SQL Server Projects with Azure SQL and DevOps Build Pipelines due to sys.time_zone_info

Question

SQL71508 - Problems with building SQL Server Projects with Azure SQL and DevOps Build Pipelines due to sys.time_zone_info

Tim Wong 10

I have a SQL Server database project which some stored procedures need to use the sys.time_zone_info object. Per this post, adding sys.time_zone_info to the project resolves the errors/warnings in the build. However, this is problematic in Azure DevOps Build Pipelines and fails with the following message

time_zone_info.sql(1,1): Error SQL71508: The model already has an element that has the same name sys.time_zone_info

Has anyone else encountered this issue and what's the workaround?

GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator

2023-08-15T13:27:31.2266667+00:00
Hi, @Tim Wong Welcome to Microsoft Q&A thanks for posting your question.

Did you try posting in the DevOps forum? Azure DevOps is currently not supported here on the Q&A forums, our Azure DevOps experts are actively answering questions in dedicated forums here:

Azure DevOps Developer Community

Azure DevOps Blog

Regards

Geetha
Tim Wong 10 Reputation points

2023-08-15T13:37:29.2066667+00:00

Thanks and I just posted this in there. FYI - The search int that comunity is horrible. Just trying to find anything with the keyword "SQL71508" returned nothing relevant in the devops section