Dependacie chain - Table with Calculated column that relies on a function

Bit of a noob here, I have been gone through the forum and tried a multiude of options and hit the wall.

When the SQL Compare element of our DLM Automation Build Runs I am getting the following warning and its stopping the build of the temp db.

The error 'Cannot ALTER 'dbo.udfStandardTel' because it is being  referenced by object 'tblCustRestPrefs'

First build is always fine if the DB is clean but latter builds of temp db always fail on this.

I have put an If exisits statement in the top of the create script for the above function (per here ), but I am pretty certain I have this in the worng place for the deploy.

Any hints would be appreciated, thank you
Tagged:

Answers

  • Alex BAlex B Posts: 1,131 Diamond 4
    Hi @dominiccollins,

    I think we'll need a bit more information and the build logs.  Since you are supported I'll reach out to you via a support ticket to get that further information and can then update here when we've figured out what's going on.

    Also, I think we may need to move this to the SQL Change Automation forum, but I'll do that in a bit.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.