You are here: Re: Deadlock within stored procedure - need help « MsSQL Server « IT news, forums, messages
Re: Deadlock within stored procedure - need help

Posted by Dan Guzman on 06/16/07 11:58

In addition to Erland's suggestion, see
http://blogs.msdn.com/sqlcat/archive/2006/04/10/sql-server-sequence-number.aspx
for tweaks to the technique Alex suggested.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"byahne" <byahne@yahoo.com> wrote in message
news:1181745584.424801.302750@o11g2000prd.googlegroups.com...
> Actually, I spoke too soon. Even using the new stored procedure we
> are getting deadlock messages, but they are less periodic.
>
> Any other words of wisdom on why this might be happening and how to
> avoid it?
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация