Be aware that performing queries towards the SQL Database should always be with no locks (add 'WITH (NOLOCK)' to every table you have in your query). It is not allowed to UPDATE, ALTER or by any means change the content of the BizTalk databases as this may result in a breach of the Service Agreement with Microsoft.
This is PowerShell scripts related to maintain and use BizTalk in a better way.
Here will you find references to other scripts in other scripting languages.
This article is also available in the following languages
Read suggested related topic:
Steef-Jan Wiggers edited Revision 38. Comment: Minor edits
Lex Hegt edited Revision 37. Comment: Ordered the PowerShell scripts
Lex Hegt edited Revision 36. Comment: Minor edits
Lex Hegt edited Revision 35. Comment: Ordered the SQL script, removed some doubles and made a couple links appear in a New Windows
Sandro Pereira edited Revision 34. Comment: fixing links format (different color)
Steef-Jan Wiggers edited Revision 32. Comment: Minor edit
Steef-Jan Wiggers edited Revision 31. Comment: Added topic Introduction
Carsten Siemens edited Revision 25. Comment: fixed typos
M.R.ASHWINPRABHU edited Revision 23. Comment: link for "View Hosts and Host Instances Information from a SQL Query" was broken. Reconfigured to actual link.
Tord G.Nordahl edited Revision 14. Comment: added reference to norwegian article
Tord G.Nordahl edited Original. Comment: Added more links
Tord G.Nordahl edited Revision 1. Comment: spelling
Tord G.Nordahl edited Revision 2. Comment: added more links
Tord G.Nordahl edited Revision 5. Comment: spelling
Tord G.Nordahl edited Revision 6. Comment: spelling
Tord G.Nordahl edited Revision 7. Comment: added tag
Lex Hegt edited Revision 9. Comment: Corrected some typos
Tord G.Nordahl edited Revision 10. Comment: added link to new script
Tord G.Nordahl edited Revision 11. Comment: added link
Lex Hegt edited Revision 12. Comment: Added the syntax for quering with no locks
Tord G.Nordahl edited Revision 13. Comment: added two more links
Great list and a very useful