469,909 Members | 1,617 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,909 developers. It's quick & easy.

AnsiNulls property broken

98
Hi All,

I'd really appreciate any feedback on the following problem:

Any Multistatement table-valued UDF created initially in SQL Server 2000 appears to have a broken AnsiNulls property if viewed with the SQL Server 2005 Management Studio. The value of AnsiNulls property is Property AnsiNullsStatus is not available for UserDefinedFunction '[dbo].[udf_MultiStatementTVF]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. At the same time, inline table-valued functions are just fine in this regard.
If I recreate the same functions on the SQL Server 2005 instance, the problem doesn't occur. I've being experiencing the issue running SQL Server 2000 SP4 Standard Edition, where the DB is, and SQL Server 2005 SP2 Standard Edition.
A similar bug in this context was previously reported and apparently fixed:
https://connect.microsoft.com/SQLSer...dbackID=126099

Please let me know if there's any workaround.

Thanks in advance,

Dave
Sep 10 '07 #1
0 841

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Frank de Bot | last post: by
6 posts views Thread by Terry | last post: by
43 posts views Thread by Steven T. Hatton | last post: by
18 posts views Thread by Robin Becker | last post: by
5 posts views Thread by Brent Ritchie | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.