I am currently working on a Windows Form application that connects to a SQL database that will be hosted on the clients PC. I am in charge of creating the actual windows application within VS2005 while a team member of mine is in charge of creating the database tables and stored proceedures. Recently, we have started to run into a very interesting phenomenon. I can not tell if my application is causing the problem or if it is SQL Server 2005. Here is what happens. We have a parameterized stored procedure that if we execute through the SQL Server Management Studio, takes only about 300 milliseconds, according to the SQL Server Profiler. Now, if I call that same procedure through my application, it takes 20 seconds to execute. I've inserted breakpoints up to the point of the stored procedure execution in my application and I am positive, the slow down does not occur until the .NET DataAdapter launches the stored proceedure. Also, the profiler specifically shows the number of milliseconds it takes to launch the query. If we copy and paste the exact same EXEC line of code from the profiler into the Management Studio, it executes exponentially faster. What might cause this? I know there might actually be many answers but this just started to happen and some times when I execute this SP with different parameters it actually executes at normal speeds. Other times there is a slow down if it is launched from the application. Any thoughts? We are completely stumped.