Most of the recieve adapter samples for sql server adapter show how to do this. Basically what you want is a polling service to retrieve information from SQL Server. That is exactly what the sql server receive adpater is ..check this out..http://msdn2.microsoft.com/en-us/library/ms935658.aspx make sure u implement the logic so that same message is not processed twice.
-Mahesh