Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deadlocks in SQL Server
Message
 
À
07/07/2009 11:16:05
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaisie
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
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:
01410627
Vues:
39
> But these tables have a page lock on them.

If you double click the page lock, what is the command you get? What are mode and owner for the lock?

It might be obvious, but just in case: The Current Activity list is never the current activity. It's just a snap shot that only changes when you hit the Refresh button or select Refresh from the right click menu.
--
Christof
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform