One possible reason is ANSI_NULLS setting is different between 2000 and 2005 when the SP is created becuase you used @NextRO = null

Try to change it to @NextRO IS NULL

USE

AdventureWorks

GO

SELECT

b.name as schema_name,a.* FROM

You need to use dynamic sql. First, build your name list firts by whatever way you want, then use the list to build the query. The pesuo code is like:

SELECT...

Yes. It's the single quotes. After removing it, it works. Thank you very much.

It's not necessary. Some DDL command and SET XACT_ABORT ON can cause a transaction is terminated outside of the try catch. The transaction is in the status of uncommitable, which...

Yes, I know the syntax is clear in the BOL. But it may depends on the  provider.

Can you try the code in my original post on your machine, and let me know...

I can see the database option when I create a C# project. It may related to the install order of SQL server 2005 and VS 2005 (I am not sure)....

One more thing. EM and 2005 SSMS are client side app. EM cannot be used to connect to a 2005 server (you will get error). 2005 SSMS can connect to...

When you install SQL 2005 on a machine that has sql 2000, you can upgrade the sql 2000 instance or install a new sql 2005 instance. If you upgrade the...

it's supported. I tried and worked fine for me

Can you check your sql sever version by running "select @@version" in query analyzer? It seems you are running sql server 2000 rtm without any service pack.

What I said is local variables (including table variable @TableName). As for local temporary table (#Table), if you define the local temporary table inside a trigger, the scope of the...

UPDATE A SET ColC=B.ColC

FROM Tbl1 A INNER JOIN Tbl B

ON A.ColA=B.ColA AND A.ColB=B.ColB

Check whether there is a file test.trc under the c: drive in your server. If the file exists, sql server will fail to create the trace.

local variable's boundary is batch. It does not matter the calls shares the same connection or not if the calls are not from the same batch.

In client side, if you...