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

Update user-defined function used by computed column

We have a table containing a computed column that uses an expression calling a scalar user-defined function.

When we alter our user-defined function we temporarily change the table's computed column expression to (0) or ('') as appropriate for the column data type. We can then alter the user-defined function without dependency errors and then change the table's computed column back to the original expression.

SQL Compare 5.1 apparently cannot currently handle altering user-defined functions in use by computed columns. Perhaps SQL Compare could use the temporary column expression method above or atleast report this dependency as a warning in the Synchronize wizard.

Thanks,

- Jason
jstangroome
0

Comments

3 comments

Sort by
  • Brian Donahue
    Having a computer column based on a UDF has been tested and should work perfectly. Maybe if you can post the UDF code, we can see if the problem reveals itself?
    Brian Donahue
    0
  • jstangroome
    I've just remembered that the computed column is persisted and has an index on it. Could this be causing problems?

    The UDF itself is quite boring. It takes a few varchar parameters as input and performs some string manipulation to return a varchar result.

    - Jason
    jstangroome
    0
  • Brian Donahue
    Following up it seems SQL Compare (5.2) still has a problem synchronizing a view when a column in the view is taken from a table's column that uses a UDF or UDT. This could be responsible for the problem.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.