problem of consuming xml message stored in database

Have you checked out my sample on Working with SQL Data in BizTalk 2006?

That same approach should work in 2004.