Deadlocks in SQL Server - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Deadlocks in SQL Server

Message

07/07/2009 11:04:11

Naomi Nosonovsky
Wisconsin, États-Unis

07/07/2009 11:02:23

Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaisie

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Maintenance bases de données

Titre:

Re: Deadlocks in SQL Server

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Windows Server 2003

Network:

Windows XP

Database:

MS SQL Server

Application:

Desktop

Divers

Thread ID:

01410522

Message ID:

01410566

Vues:

>Naomi,
>I've added the nolock option into the SQL statement. There's still a page lock.
>Yau

What indexes do you have on your table and when did you re-build them last time?

If it's not broken, fix it until it is.

My Blog

Répondre

Fil

Voir

Click here to load this message in the networking platform