I am making the assumption that it always runs slower, even when it has a chance to get its execution plan.

A couple of questions:

When the stored procedure is called, it...

It meant SQL Server was opening the database files for database ABC and getting it ready for use. Typically all databases are marked in this manner when the SQL Server...

The account doesn't need to an admin, but it does require you check some registry and file permissions. Here's the relevant Books OnLine page from MSDN:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_overview_6k1f.asp

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Here is Steve's posted script:

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Each service pack they fix more and more memory leaks. For instance:

Bulk insert abort memory leak (fixed in SP3):

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

Bulk insert from stored procedure (fixed in SP2):

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

SQL-DMO Parameter By Reference Memory...

Here's an FAQ on SQL Mail. There is a server-side Exchange MAPI that can be installed (see Q9):

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

The problem with it is it doesn't have any means of creating profiles....

How are you retrieving it? Through a web interface? If so, are you setting the HTTP headers properly?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

I have found through testing that processes executed by SQL Agent tend to run slower than executed manually. One work around is to have the job step execute a command...

Is one of the versions SQL 7 Desktop Edition? If so, here a relevant article:

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

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

DanaH, what version and service pack is the SQL Server?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Right but the catch is the user account/password on the client machine has to match exactly the user account/password on SQL Server in order to use Windows authentication. Under a...

Glad to help.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

If this has occurred every time (and not just a one-time anomaly), you may want to contact Microsoft. This may be a genuine bug. I'm not seeing anything in the...

Do you happen to have matching user accounts/passwords on the two Win2K machines/SQL Server?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

I apologize. I was asking the question of DanaH. There are some fixes in the various service packs for memory leaks.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/