Launching a "Fire and Forget" stored procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maury - 06 Jul 2007 08:41 GMT

Hello,
I have an asp.net applicaiton and I woul like to add some logging
features
(not only for errors but even for user activities), my principal
interest is to NOT
decrease performance so I would like to launch some SQL Server 2005
stored procedures in a "Fire and Forget" way: the application launch
the Stored Proc
and continues without waiting ...
Is it possible? How?

Thanks!
.:M.A:.

Reply to this Message

sloan - 06 Jul 2007 09:08 GMT

I think inside of Sql Server 2005, the concept is "Service Broker".
http://www.codeproject.com/dotnet/IntroServiceBroker.asp

From the dotnet side of things, you can create a WCF call, using msmq on the
backend. This is 3.0 specific because WCF is 3.0 specific.
http://dotnetslackers.com/ASP_NET/re-57397_ASP_NET_Request_Logging_with_Asynchro
nous_Fire_And_Forget_Pattern.aspx
...

I hope the "hints" help.

The second link looks right on target.

> Hello,
> I have an asp.net applicaiton and I woul like to add some logging
[quoted text clipped - 9 lines]
> Thanks!
> .:M.A:.

Reply to this Message

sloan - 06 Jul 2007 09:09 GMT

Sorry Peter!

http://eggheadcafe.com/tutorials/aspnet/aa5ff306-16a1-4014-a51d-6ffde0894a0d/asp
net-request-logging-w.aspx
(for the second one I posted)

is the direct link.

> Hello,
> I have an asp.net applicaiton and I woul like to add some logging
[quoted text clipped - 9 lines]
> Thanks!
> .:M.A:.

Reply to this Message

Launching a "Fire and Forget" stored procedure

Free Magazines