Home Forums SQL Server 2005 Administering Adhoc queries and deadlocks. RE: Adhoc queries and deadlocks.
stephen.christie
SSC Eights!
Points: 895
More actions
July 17, 2008 at 2:12 am
#844199
I would agree, straight conversion from Query to Stored Proc would not stop dead lock.
Rather get the queries working right then convert them to a stored procedure.