Interesting article on how SPS 2003 was configured to work with SQL Server 2005: Guide to Reinstall - Migrate SPS 2003 to SQL 2005
There is also a useful link in the article on how to secure your SPS 2003 Portal
TRY/CATCH blocks can be used to help resolve a deadlock.
SQL Essentials: Using TRY/CATCH to Resolve Deadlocks in SQL Server 2005
Davide Mauri has found a bug in SQL Server 2k5.....now how did they let this slip through...