HOw do I set up Asynchronous Processing in SQL Server 2005.
There are bunch of user activity recording SQL statements which run as and when a user hits a particular page. This is not a time sensitive data, the actual updates could be delayed. I was hoping for some way of putting all this into a queue and have it processed asynchronously (without having to write scheduler jobs and such). This could help significantly with the page load times and SQL connection contention assuming an increased traffic.
"More Green More Oxygen !! Plant a tree today"