Launching a "Fire and Forget" stored procedure

[Maury]

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:.

 

[sloan]

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/r...ith_Asynchronous_Fire_And_Forget_Pattern.aspx
....

I hope the "hints" help.


The second link looks right on target.

 

[sloan]

Sorry Peter!

http://eggheadcafe.com/tutorials/as...1d-6ffde0894a0d/aspnet-request-logging-w.aspx
(for the second one I posted)

is the direct link.