But I just have problem when I change "Hide Instance" to Yes. I don't have this issue before.

Your comment is good but what a pity I don't have second server to exchange 😎

I little bit confuse, what's difference source and destination column in your sample, you call "Row" but SQL 2000 separates "DTSSource" and "DTSDestination" ?

Yes, but how to use Script or Derived Column to make function like that of SQL 2000.

Please guide me.

Function Main()

if (DTSSource("ID")<>"" and DTSSource("CODE")= "123456" and isNumeric(DTSSource("INTERFACE"))) then

...

OK, thank you very much.

Is it possible to upgrade from SQL 2000 x32 to SQL 2008 x64 by detach data files from SQL 2000 x32 and attache them to SQL 2008 x64 ?

As I said, for some reasons now I don't want to upgrade to SQL 2005 or 2008 so much.

So I think the temporary best way now is install SQL Server...

Should I have another question.

Is there version of SQL Server 2000 Enterprise 64-bit for server Hewlett-Packard DL360 G6. I try to search in Internet but only get version 64-bit for...

Yes, of course I will upgrade to Enterprise version

But as my second question, I'm worry about stabilization of Windows because at that case Windows has only 1GB for kernels.

Do you mean to use parameter /PAE...

Any advice please ? Thanks.

But when I use "WITH RECOVERY", I can't restore next new log file into database any more

Any body comments please!

Thanks for your advice!

Could you help me next question:

USER1 is owner of [user1].[Table2]

How to PREVENT him access (SELECT, INSERT, UPDATE, DELETE) to [user1].[Table2] directly, I want to let him just...

I think this way equals to setup Log On account on screen of Windows services configuration