October 31, 2005 at 9:39 am
Any idea why message 1205 would have :
Transaction (Process ID %d) was deadlocked on {%Z} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
on one server and
Transaction (Process ID %d) was deadlocked on %.*ls resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
on other servers including what should be an exact mirror of the server that has the first message.
The {%Z} returns basically garbage to the application.
Thanks!
October 31, 2005 at 10:41 am
according to the books online sql 2000 gives
Transaction (Process ID %d) was deadlocked on {%Z} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
perhaps the other server is sql 7?
October 31, 2005 at 11:12 am
My Books Online also has the message containing {%Z} instead of %.*ls but the actual text in sysmessages does not match.
Perhaps this has something to do with internalization(languages) ?
Try running the below and see if there are differences between the two servers:
exec master.dbo.xp_msver 'ProductVersion'
go
select SERVERPROPERTY('Collation'), @@LANGUAGE
Here is the sysmessages text from SQL 7, 2000 SP3 and 2000 SP4. None have {%Z} within the messsage text.
8.00.2039 SP4 Transaction (Process ID %d) was deadlocked on %.*ls resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
8.00.760 SP3 Transaction (Process ID %d) was deadlocked on %.*ls resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
7.00.1094 Your transaction (process ID #%d) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
SQL = Scarcely Qualifies as a Language
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply