Paul,

At this stage, it is for testing and debugging. Eventually, this SP could be released to other users around the business so it would then become informational for the...

Hi Paul,

Thanks for your efforts on this one.

The reason for wanting to return the Contraint Name and Definition in the catch block is because there are multiple constraints...

Hi Paul.

Thank for you help. I have had a play but I am getting nowhere fast.

I have got this so far:

select *

from sys.table_types as TT

INNER JOIN sys.check_constraints as...

Hi Paul.

Thanks for your response. Does that mean that I should be able to link the value returned in the Error meassge that is raised due to the check...