Or just open Query Analyzer, connect to the remote server, open the file, select the correct database, and then hit F5.

If they are used to using 6.5 it might be time to look for a new vendor

Here's another good article to run through on parameter sensing.

http://blogs.msdn.com/khen1234/search.aspx?q=parameter+sniffing+recompile&p=1

Can you see any differences between the estimated query plans of the plain sql and stored proc version?

Did with recompile...

Can you post your procedure please? Include the whole thing if you can.

One quick thing to try though is to insert WITH RECOMPILE to test to see if you were...

Sorry, posted too soon there.

As Carl said, sp_OaCreate is the most likely reason for memory leaks. You should also investigate whether or not they are use extended stored procedures written...

If you believe there is a memory leak in SQL Server, you should get perfmon out.

I've had this problem on 2003, not necessarily on a cluster.

Check out this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;817064

If you haven't, also take a look at this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;301600

and this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;889706

Is the MSDTC service started?...

My guess is that you might be seeing something like a table spool, where a temporary object is created in tempdb.

You need to check the estimated plan and see where...

Agree with Alexander's post on this, although I would like to point something out from an earlier post that was not quite right.

SQL Server keeps the row counts updated in...

As far as I was aware, it wasn't that this was a secret, it was just so obvious that noone bothered to mention it before.

And certainly not with so many...

Hi, There are some tools out there that can assist with this type of requirement:

http://www.lumigent.com/products/le_sql.html

http://www.red-gate.com/sql/sql_log_rescue.htm

As far as I know, these tools are loosely based around the...