Hi Jane,

If you look in BOL you'll see that ISQLW cannot be called with a parameter stating which protocol to use. In fact the [only] parameter availlables - according to BOL...

Hi,

I have the same behavior as Cris. We are on SQL2K SP3A.

Regards,

Carl

You can also use the sp_helptext stored procedure to get the text of a stored procedure (in Query Analyzer or osql):

sp_helptext sp_xxxxx

Regards,

Carl

The solution is very simple: Install service pack 3. After having done that, the server listen on the TCP/IP port defined by us.

Ouups, instead of you should have seen:

 - Lock: Deadlock

and

 - Lock: Deadlock Chain

Hello Dale,

Seen lately that with SQL Server 2005 it will be displayed graphically in a user friendly fashion.

But having to work with 2000, have you tried with the profiler using...

Hi Remi,

Its nothing. In the past you have also contibuted a lot the this site.

By its "nature" lock escalation increase the possibilty to get deadlocks.

Carl

From BOL:

Lock Escalation

Lock escalation is the process of converting many fine-grain locks into fewer coarse-grain locks, reducing system overhead. Microsoft® SQL Server™ 2000 automatically escalates row locks and page...

Also, maybe lock escalation is involved... not sure.

Carl

Hi Noel,

Something I should have mention previously is that the Edition of SQL Server 2000 is the Personnal one.

But I don't think this is the bug we experience here since...

Hi Dale,

To be honest when this situation arise we were having a lot of other troubles involving LOCKs, DEADLOCKs, application bugs, ... it was in the summer of 2002.

We were...

Hello Noel,

Hide Server is not checked.

Thank's for that hint it could have been checked.

In the SQL log what Isee is this:

SQL Server listening on Shared Memory, Named Pipe.

Nothing related...

Hello Jason,

not this is a default instance not a named instance.

Regards,

Carl

Hello Chris,

Our installation is on XP as stated above and the Windows Firewall is "ON".

If I try to add exceptions with the port 1433, it does not solve the problem.

I...

Hello Chris,

its a good point... They've increased the security on all our laptops lately... maybe its related.

I'll look at it when I have the chance to get one. Until then, ...