Saturday, February 25, 2012

Message Queue

Hi, I have a question, I don't know if it is possible but I have an
application (.NET) that executes queries against SQL Server 2000. I have an
scenario where the database maybe is offline. I have been working with MSMQ
to communicate between apps and send messages from SQL Server but my questio
n
is if SQL Server can read from the queue.
I want to send the query to a queue and when SQL is up again read from the
queue and process the queries, is this possible?
ThanksHi
You need to do that in code. SQL Server 2000 does not process against
message queues.
Regards
Mike
"Salvador" wrote:

> Hi, I have a question, I don't know if it is possible but I have an
> application (.NET) that executes queries against SQL Server 2000. I have a
n
> scenario where the database maybe is offline. I have been working with MSM
Q
> to communicate between apps and send messages from SQL Server but my quest
ion
> is if SQL Server can read from the queue.
> I want to send the query to a queue and when SQL is up again read from the
> queue and process the queries, is this possible?
> Thanks
>

No comments:

Post a Comment