A big advantage of using stored procedures is that you have a common interface to the db, so you do not have to rewrite your SQL-creation code for different applications...

Very good article. For some time I have been trying to look beyond the hype about XML to see where it can be truly useful and where to avoid it....