Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Aysncronous Process Completes without batches

Author  Topic  lholden Starting Member 5 Posts Posted - 2010-05-19 : 11:42:14 Hi, I have developed a small web app that fires an asyncronous command to execute a stored procedure on my SQL 2000 database. When i run this on my development machine it works fine, I can run profiler and see the RPC:Starting, followed by a bunch of SQL:BatchCompleted (which I can see is executing the commands in the proc), and then an PRC:Completed; everything has worked as expected. When I migrate this to my Live machine and run a trace I get the RPC:Starting immediately followed by an RPC:Completed and the proc doesn't do anything, but doesn't throw any errors either. I have Asynchronous Processing=true in my connection string (in my web.config) on both servers, and from all of the other IIS and SQL settings that I can find, both machines look to be configured the same. the only difference is that Live is version 8.00.2282 and Dev is version 8.00.2055 - I am using an SQL user in my connection string which is sysadmin on both machines - i thought this might have been something to do with the different version & non-trusted connections, but I have ruled this out by changing both to use NT Authentication with the same results. any help is much appreciated. Lee