Posted by Erland Sommarskog on 10/01/96 11:42

(jim_geissman@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, 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: To retrive a table from one database to and another database(same table)
• Prev in forum: Alternative to OpenXML
• Thread view: Re: 2000 vs 2005 -- AnsiNullsStatus

[Reply to this message]