Biztalk SQL Server management and optimization

I found two great posts about biztalk server 2004/2006 DB optimization, deadlock solutions.
I suggest everyone who work with biztalk to read this posts.

1. http://support.microsoft.com/kb/917845
2. Biztalk core engine's WebLog - What you can and can't do with the Messagebox Database server.
   

Summery :

• Don't enable/use statistics.
• Shutdown the parallelism.
• Don't built maintenance plan for indexes, use only bts_RebuildIndexes stored procedure, shutdown biztalk engine first.
  
• Don't change the stored procedure code.
  

enjoy,

Expose Stored Procedure with SQL 2005

I needed to expose a SQL 2005 stored procedure as Web Service. I searched the net and found that it can be done straight forward by the SQL 2005 tools , the End Points.
It is very simple to do it follow this link

http://msdn2.microsoft.com/en-us/library/ms345123.aspx#sql2005websvc_topic4

really three steps and you done:

1. Create the stored procedure.
2. Create the End Point that exposes the stored procedure.
3. Grant the user access to the end point.