Thanks Steve. On a related issue, I'm interested in your opinion re splitting your applications from your database server onto a seperate app server. I'm not thinking about...

We have a 4 processor server (not hyperthreading as far as I know) running Windows 2000 Server (Build 5.0.2195) and SQL Server 2000 SP3 build (8.00.760).

I'll speak to the provider...

Hi. I forwarded your responses to our provider and received the following reply:

1) Yes, the objects are properly released.

2) Memtoleave exhaustion whould indicate a memory leak, something...

1) YES

2) I'll look into this one.

3) I am using NOLOCK.

Steve, what books are you working on? you must let is know when they are published so we can take a look 🙂

Well done Steve!

Another point that pay have been mentioned already - if you are going to quote another author's work, then that is OK but you MUST give them credit....

Not to worry, guys. I found the solution on

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

us;816939

(I should have read Carl's posting better.)

Regards,

Wayne

Can you tell me how to make the change? I notice there is a column called status that seems to have an impact, but we are not sure what...

I wonder if Steve realized what he would be starting! 🙂 Dynamic times we live in...

Hi Steve. Hope you enjoy your holiday... Can't say I agree with everything your armies have done in the past, but there has been some good (i.e. WWII). ...

We get this error:

Error: disconnecting from server mail.***********.net failed [SQLSTATE 01000] (Message 0). The step failed.

I'd just like to add that SQLServerCentral is doing a great job!  It is extremely useful to be able to log a problem and get such excellent and accurate responses, especially if...

A colleague of mine found this:

http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx

Seems the next step for me is to bounce SQL.

Thanks!!!

I can't find MaxPropStoreCachedSize in that spot in the registed.  Must I create a new entry?

I didn't see any deadlocks.

The drives are RAID 5, about 300 GIG.  6 CPU's and 4GIG RAM.

The Full Text catalogs are on the same drive as the databases (D:\MSSQL\FTDATA).  I...