473,241 Members | 1,481 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

2000 vs 2005 -- AnsiNullsStatus

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."

Any idea how to overcome this? It seems like a minor detail that
should be fixable by setting something at a global level. BOL has
several entries for AnisNullsStatus, but I don't see anything that
looks like a solultion to my problem.

Thanks,
Jim Geissman

Mar 16 '06 #1
6 3344
(ji**********@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 16 '06 #2
Thanks, Erland. I interpret that as: call up the code in a 2000 Query
Analyzer, and then paste it into 2005 Management Studio, which will add
the necessary stuff. Is that right? (Yes, the server is 2000.
Strange that the client would be more picky than the server.)

Jim

Mar 17 '06 #3
(ji**********@countrywide.com) writes:
Thanks, Erland. I interpret that as: call up the code in a 2000 Query
Analyzer, and then paste it into 2005 Management Studio, which will add
the necessary stuff. Is that right?
Not really sure what stuff that Mgmt Studio should add. You could stay in
QA if you prefer.
(Yes, the server is 2000.
Strange that the client would be more picky than the server.)


SQL 2005 has a completely new way of accessing metadata, and of course
Mgmt Studio uses that on SQL 2005, so there are different code paths for
SQL 2000 and SQL 2005.

It's of course a bug, nothing else.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 17 '06 #4
Hello, Jim

It's an known bug, that will be fixed in SQL Server 2005 SP1. See:
http://lab.msdn.microsoft.com/produc...5-62d1fb31d0a4

Razvan

Mar 17 '06 #5
Thanks, Erland and Razvan.

My comment:
Thanks, Erland. I interpret that as: call up the code in a 2000 Query
Analyzer, and then paste it into 2005 Management Studio, which will add
the necessary stuff. Is that right?

Not really sure what stuff that Mgmt Studio should add. You could stay in
QA if you prefer.

....was an attempt to find a way to work on the UDF in Mgmt Studio,
because I don't have the 2000 tools on the new workstation. But for
UDFs it looks like it will be easier to stay with the 2000 client on my
laptop, as you suggest, until SP1 appears.

Jim

Mar 17 '06 #6
Razvan Socol (rs****@gmail.com) writes:
It's an known bug, that will be fixed in SQL Server 2005 SP1. See:
http://lab.msdn.microsoft.com/produc...5-62d1fb31d0a4


Unfortunately, they have only fixed it in part. When testing in the SP1 CTP,
I find that Modify and Script Function as Alter still fails, interesting
enough with a different error message than in RTM. The one comfort is
that Script Function as Create now works.

I've reopened the bug, so that people who sees the resolution from Microsoft
do not get false hopes.

Jim, you can run the SQL 2000 tools in parallel with the 2005 tools on
the same machine.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 18 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: AlessanBar | last post by:
Hello Friends !! I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration: Pentium III Brand : Toshiba Speed :...
1
by: lourivalsjr | last post by:
Hi, i have SQL 2000 and 2005 on same machine(with different intance names, of course), my laptop - XP with SP2. The 2005 works fine but i can't connect on SQL 2000. All the the SQL services are...
3
by: pb648174 | last post by:
I recently needed to upgrade a sql 2000 machine to 2005. Instead of upgrading the sql 2000 default instance, I installed sql 2005 as a separate named instance so we could go back to sql 2000 if...
1
by: HandersonVA | last post by:
database has been recently upgraded from ms sql 2000 to ms sql 2005. are there anything I need to be aware after upgrading to ms sql 2005? for my experience, i got an error if i use column alias...
1
by: Alex | last post by:
Hi Everyone, Most of our MS SQL Servers are still running on SQL 2000, but being I will soon be upgrading my workstation to Vista Business I'd like to install MS SQL 2005 Enterprise Manager to...
11
by: HC | last post by:
I posted this in one of the VB forums but I'm starting to think it might be more appropriate to have it here, since it really seems to be a SQL server (MSDE/Express 2005) problem: Hey, all, I...
2
by: Luke.Schollmeyer | last post by:
I found an unusual problem between 2000 and 2005 I haven't been able to decipher from any documentation. The query structure is as follows: select * from tableA a join tableB b ON...
2
by: JA | last post by:
Is it possible to connect to Sql Server 2005 using an Access 2000 adp? I keep trying, but it doesn't want to accept my id, even though it is right.
5
by: brian.j.parker | last post by:
Hey all, I've noticed an obscure little quirk: it appears that if you use a login with trailing spaces on the name, SYSTEM_USER automatically trims those trailing spaces in SQL Server 2000, but not...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.