Great point about being able to read any page. Thanks!

Ned

You're right! Once I dropped the image column and ran my one row delete I got:

1 X KEY

1 IX TAB

1 IX PAG

Thanks for the idea.

Got a link?

So if each instance gets a private virtual 3 GB why not configure the 4 instances like this?

Instance 1 - 4 GB

Instance 2 - 4 GB

Instance 3 - 3 GB

Instance...

Hi Addict. Would you be so kind as to elaborate on why this is a good configuration. It does not make sense to me because the total of the...

Hey Bidec. Have you reconfigured your instances yet? If you did, how did you configure them? I'm going to have to do the same thing on mine so I would...

Check your sql error logs. Do they say AWE enabled? I had the same problem and found that you have to set the max server memory to a minimum...

Thanks for your help John.

Mike the variables are nvarchar and text.

Noel

Thanks John,

So following that logic then, could I set the Microsoft Search Service to run under the SQL Service account?

Are there any security concerns to doing this?

Setting the search service...

There is a SQL Server 2000 Licensing Setup icon in the control panel.

I am by no means an expert on this, but I would think you make a 3 node cluster with two active and one passive. Then put the passive server...

What is the database name? I'm wondering if there may be a space in the name or an odd character. Also, does the database owner still exist?

You were correct Chris. The problem seems to be related to the 1536 Max Server Memory Setting. It seems that that magic number is 3 GB. When I have the...

First of all you must reside in Calgary Alberta Canada.

The duties are traditional physical DBA duties. Install, configure, backup performance tune SQL 6.5, SQL 7 and SQL 2000. No need...