Hello Bill,

It is not a contradiction. It is only a "new" paradigm.

In the past (before snapshot), SQL server uses locks to ensure you cannot read the modified row until the...

In my previous example I mistypes the login. You should have read:

create login 'MyUser' with password = 'MyUser', default_database = MyDb

go

use MyDb

go

create user MyUser for login MyUser with default_schema =...

Hello Leon,

I remember that in our case, to problem was related to MDAC.

So in your case, clearly, it seems to be something else.

If I think about something I'll let you know.

Regards,

Carl

Ok. You're rigth its not a must to install the client part of SQL Server.

Do you have the same MDAC version on your XP's workstation than the one on you...

Ok I suppose the client version of SQL Server on you Citrix Server is 2000 also. True?

With the same service pack?

Regards,

Carl

Hello Leon,

does all your servers an workstations having the same SQL Server version?

In the past we encounter similar problems but it was not involving server to server connection just client to server....

I am aggree with you: BOL should mention it.

I would have search for a long time if Frank was not such an "encyclopedic" guy

Hello Arumugan,

What is your problem(s) exactly?

You could use the COLLATE keyword in the ORDER BY clause.

You could also (i don't know if it is your need) add a column stating...

Hello Horace,

you could also get some valued informations with this book:

Oracle8i and Microsoft SQL Server 2000 Integration

Stephen Chelack

M&T Books

ISBN#: 0-7645-4699-6

Date Published: 12/00

Hope it will helps,

Regards,

Carl

Hello Fariz,

The server you tried to contact must have a listener process. This process (listener) will spawn a server process as you connect to the instance.

This error means that there...

Suggestion: This discussion should have been post in the Globalization forum.

For further reference it is clearer.

Regards,

Carl

Hi Subu,

Don't think you can do that in SQL Server.

The concept of packgae does not exists.

Maybe you can achieve the same result doing it another way.

Regards,

Carl

Hello Naomie,

If you want you can also dowload and try the: Best Practice Analyzer from Microsoft.

It scans your server and gives you an interesting report. After that you can choose...

Nice to learn.

Thanks,

Carl

Hi Jane,

On the command line when calling isqlw?

If you find it again, please post it because it is not in the documentation.

Regards,

Carl