Ah!!! That explains a lot, thank you kindly.

Hi Scott,

I don't have an issue with the setting in an operational sense. I am just curious about how to interrogate the server as to what that setting is....

Hello Gentlemen,

I appologise for the vague question, obviously not correctly asked. What i am after is to find out what is set on a database with the

Alter...

It appears as if the server pops the brackets around the function name as well. The text value in syscomments for the created table that i posted is:

([DBO].[ColumnName]([AlsoAColumnName])...

Thanks, that's a good solution. I unfortunately found a bit of a problem with it. It will return a false positive in the situation where a function with...

Looks to me like the server is differentiating between a syntax error and a error during execution. They are different things. For instance you've got 'craete table' somewhere in...