Hope this will be the case too.

Thanks to all of you.

Carl

Thank's for your intput Collin,

Carl

In the late 90, when we were using NT4.0 as the O.S. on the database server, we were doing that for the stability (I guess because I was not here). I...

Hello Ja,

Changed the cursor type to use the FOR UPDATE close. It solved the peformance issue with OSQL .

But I still don't understand...

But you suggestion on putting debugging informations (datetime) in the script could lead me to an answer.

Thank's

Carl

Hello Ja,

SQL Server 2000 sp3a.

No specific parameter for OSQL.

I cannot see why the difference between OSQL and ISQLW would be because of the commiting work every 1000 records. It should be treated...

Yes, no problem here is the script (for sure it can be done differently but it would not explain the huge difference between ISQLW and OSQL):

SET NOCOUNT ON

GO

DECLARE c_measure...

Finally found in an article that, since SQL Server 7.0, the behavior of BCP changed since it is no longer based on the DB-Library API.

The switch "Automatic ansi to oem conversion" ...

Hlello John,

Not always like GO... try this one:

select @@version;

sp_who

Versus:

select @@version

go

sp_who

The first one gives an error:

Server: Msg 170, Level 15, State 1, Line 3

Line 3: Incorrect...

Hello John,

can you be more explicit on the meaning of ';' in QA or ISQL/OSQL?

What is its purpose? An example?

thank's a lot,

Carl

I looked in the registry under:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\tools\ClientSetup\CurrentVersion

I would have tougth that:

If 

8.00.194  Then SQL Server 2000 original release

If 

8.00.384 -> SP1

Si

8.00.534...

Helo Ramesh K,

sp_executesql give you the opportunity to use parameters. When executing similar satements that are different only on values for those parameter, you can have a performance gain due...

My question was suppose to be:

"How can I verify which service pack is "installed" on a SQL Server 2000 client?"

Instead of:

"How can I verify which service is "installed" on a...

Hello Michael,

I should have written "Standard Edition" not "Personnal Edition". It is an error.

But I solved my problem installing the service pack 3a.

Best regards,

Carl