SQL Packager & SQL Server SP1: Self Deadlocking Transactions
With reference to a previous "conversation" (http://www.red-gate.com/messageboard/viewtopic.php?t=3567) and to a blog entry made by Andras (http://www.simple-talk.com/community/blogs/andras/archive/2006/06/09/859.aspx), I wonder whehter you would be able to answer a couple of questions.
We are experiencing the problems detailed by Andras, when deploying a SQL Packager "package" onto a client's SQL Server 2005 server. They have SQL Server 2005 SP1 installed, and we have been using SQL Packager 126.96.36.199.
Firstly, do you know whether the latest version of SQL Packager, 5.3, resolves the issues? Does it spilt out the XML Schema definitions into a separate transaction from its usage?
Secondly, do you know whether MS have changed how these works (aka. "fixed it") with SP2 or with a specific hotfix? I have not been able to find an MS article that describes the problem or mentions a fix.
Thanks for you time,
Senior Software Engineer,