Hi,

I have a SQL Server DB which biztalk monitors for any new or updated
records.

Is there any way to let biztalk know that a record needs to be picked
instead of biztalk constantly polling sql server


-Regards,

[ Post a follow-up to this message ]

I have considered using a SQL Server trigger. The trigger would then write
out a file or something to communicate this to BizTalk. But I never took
this through to completion.

I find that polling SQL Server is suitable in most scenarios and is a breeze
to set up.

What is your motivation for event based rather than polling based
notification?

--
McGeeky
http://mcgeeky.blogspot.com


"Kallu" <Kallu@discussions.microsoft.com> wrote in message
news:6166F868-149F-40B9-B473-673CB3EF856C@microsoft.com...
>
> Hi,
>
>  I have a SQL Server DB which biztalk monitors for any new or updated
> records.
>
>   Is there any way to let biztalk know that a record needs to be picked
> instead of biztalk constantly polling sql server
>
>
> -Regards,

[ Post a follow-up to this message ]

Hi McGeeky,

The data would be read from different tables and i thought if theres any
other efficient way to get the messages(records)

Would it be possible for the Trigger to write the messages to MSMQ?


-Regards,

"McGeeky" wrote:

> I have considered using a SQL Server trigger. The trigger would then write
> out a file or something to communicate this to BizTalk. But I never took
> this through to completion.
>
> I find that polling SQL Server is suitable in most scenarios and is a bree
ze
> to set up.
>
> What is your motivation for event based rather than polling based
> notification?
>
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
> "Kallu" <Kallu@discussions.microsoft.com> wrote in message
> news:6166F868-149F-40B9-B473-673CB3EF856C@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

I have not done it myself (accessing MSMQ from a trigger), but T-SQL is
pretty powerful and virtually anything is possible; for example using COM or
running an external program. But it starts to get a bit messy. It might be
more trouble than its worth. Perhaps you should look further up-stream to
see what is writing the data in the first place and if that is a more
suitable place to put a hook in to BizTalk.

If you do have some success with a trigger then please let me know as I'd be
interested to see how you get on.

--
McGeeky
http://mcgeeky.blogspot.com


"Kallu" <Kallu@discussions.microsoft.com> wrote in message
news:19EC10F2-D284-4CA6-9681-C445C0DF02F1@microsoft.com...[vbcol=seagreen]
>
> Hi McGeeky,
>
> The data would be read from different tables and i thought if theres any
> other efficient way to get the messages(records)
>
>  Would it be possible for the Trigger to write the messages to MSMQ?
>
>
> -Regards,
>
> "McGeeky" wrote:
> 

[ Post a follow-up to this message ]

Sure, thanks for your suggestion

-Regards,

"McGeeky" wrote:

> I have not done it myself (accessing MSMQ from a trigger), but T-SQL is
> pretty powerful and virtually anything is possible; for example using COM 
or
> running an external program. But it starts to get a bit messy. It might be
> more trouble than its worth. Perhaps you should look further up-stream to
> see what is writing the data in the first place and if that is a more
> suitable place to put a hook in to BizTalk.
>
> If you do have some success with a trigger then please let me know as I'd 
be
> interested to see how you get on.
>
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
> "Kallu" <Kallu@discussions.microsoft.com> wrote in message
> news:19EC10F2-D284-4CA6-9681-C445C0DF02F1@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]