You will need to use a Trigger to create a message and send this to Biztalk.
There would be a number of options for sending the message including MSMQ or SQL Service Broker .
Check out Jesus Rodriguez SQL Service Broker Enhancements on GotDotNet:
[url]http://www.gotdotnet.com/Workspaces/Workspace.aspx?id=f2e863c6-3444-47ae-8d13-668484a449f9[/url]