Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can a SP deadlock with itself?
Message
De
12/03/1999 08:38:21
 
 
À
11/03/1999 19:10:41
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, Royaume Uni
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00196295
Message ID:
00196744
Vues:
62
First,

Try replacing the SELECT INTO with an explicit CREATE. Fill the temp table with and INSERT SELECT (see BOL for the syntax). Hopefully that will stop your deadlock problem (it did mine).

You can use DBCC SHRINKFILE to shrink your log file. You might try truncating the log first.

Good luck

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform