AnsiNulls property broken - Microsoft SQL Server

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

Subscribe Post Reply

909

Similar topics

broken pipe error

by: Frank de Bot | last post by:

Hi, occasionaly I find in my apache logs that fastcgi had a broken pipe error with php running as fastcgi. the logs are like this: -- > (32)Broken pipe: > FastCGI: comm with server...

PHP

margin property for BODY

by: Terry | last post by:

I'm real new at this, so this may be a basic question, but I want to get off on the right foot. I thought it would be reasonable to use the following on a page: body { margin: 3em;...

HTML / CSS

Alternatives to the C++ Standard Library?

by: Steven T. Hatton | last post by:

Now that I have a better grasp of the scope and capabilities of the C++ Standard Library, I understand that products such as Qt actually provide much of the same functionality through their own...

C / C++

Javascript error headache: object doesn't support this property or method

by: news.onetel.net.uk | last post by:

I and my friend Karl have spent literally all day trying to find out what is causing my error but we are zapped of any further functionality :) I have a form that adds news records. You select...

Javascript

override a property

by: Robin Becker | last post by:

Is there a way to override a data property in the instance? Do I need to create another class with the property changed? -- Robin Becker

Python

Feature Request: Hiding a property/method in a subclass

by: Jeroen Smits | last post by:

To Microsoft or other people who are interested, I have a feature request: I would really like to have an option to 'hide' a property or method from an inherited class. For example when I create...

C# / C Sharp

using internal or protected vs. property accessor

by: TS | last post by:

what would be the scenario that you would want to declare a variable of a class in that fashion instead of a public property accessor?

C# / C Sharp

show/hide the XML Serialization of a public property of enumerated type

by: student | last post by:

In Summary: Create an object - dont set one of its Enum Type properties and make sure it does not appear in XML Object Serialization. Strings function as hoped for but Enums do not Heres my...

Visual Basic .NET

C++ Property template

by: Brent Ritchie | last post by:

Hello, This is my first attempt at template programming so please bear with me. This is what I have so far: Property.h -------------------------- #ifndef PROPERTY_H_ #define PROPERTY_H_

C / C++

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing