Hi all.
Here is my problem.
We have a SQL procedure that we were calling in a development environment, no problem… ran fairly fast…. no difference between the time it took to run in SQL server management studio and the VB app.
We move it to a staging environment…
The proc takes a few seconds longer to process on SQL Server, (about 12 seconds) but it takes about 3 minutes to process through Visual studio.net.
The only thing I changed was the server name in the connection string.
Does anyone know what could do this?
