Posted by Erland Sommarskog on 09/26/58 11:42

(jim_geissman@countrywide.com) writes:
> I created a lot of procedures and functions using QueryAnalyzer from
> SQL 2000. Now I have a new workstation, and installed SQL 2005.
>
> The code on one particular server seems to be inaccessible. When I go
> to edit ("modify") objects, or copy them to the clipboard, I get the
> message, "Property AnsiNullsStatus is not available for <this object>.
> This property may not exist for this object, or may not be retrievable
> due to insufficient access rights."

This is known issue with SQL Server Management Studio that it does not
handle user-defined functions on SQL 2000.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Sql Server Performance
• Prev in forum: Re: bcp right truncation: how to ignore
• Thread view: Re: 2000 vs 2005 -- AnsiNullsStatus

[Reply to this message]