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

Dropping Schemabinding?

We have some functions that are defined "With Schemabinding" and when deploying including dependencies, RG Compare creates scripts such as

PRINT N'Removing schema binding from ...
...
ALTER FUNCTION ...
(
...
)
RETURNS Table
WITH
RETURN
(
    SELECT
...


But this is obviously a syntax error.  Am I missing some options somewhere?  Thanks



davesbrown
0

Comments

3 comments

Sort by
  • Pete_Ruiz
    Hello @davesbrown

    Thanks for reaching out and sorry that you're having trouble with SQL Compare.

    I tried a few scenarios on my end to try to try to replicate this but no luck.

    Can you please provide CREATE scripts for the function as it appears in the source as well as in the target so we can try and replicate this?

    Kind regards,

    Pete Ruiz
    Product Support Engineer
    Pete_Ruiz
    0
  • davesbrown
    He @Pete_Ruiz

    Thanks for the reply.  I think we solved the issue with some overlooked filters and checking deploy with dependencies; we had some dependent views.

    Thanks,
    Dave
    davesbrown
    0
  • Pete_Ruiz
    Hello @davesbrown

    That's great news. Glad you were able to resolve the issue.

    Please reach back out if anything else comes up.

    Cheers,

    Pete Ruiz

    Product Support Engineer

    Pete_Ruiz
    0

Add comment

Please sign in to leave a comment.