I want to thank you all for looking. I personally haven't run into this kind of issue on any of the servers I have managed in the past 12...

GilaMonster (6/30/2009)

---

Lynn Pettis (6/29/2009)

---

Okay, I'll admit it if I am wrong, but I'd really like a few others opinions on this one please.

My only problem is 30 years of experience...

Okay, I'll admit it if I am wrong, but I'd really like a few others opinions on this one please.

My only problem is 30 years of experience just has my...

hi_abhay78 (6/29/2009)

---

Its good to do that .But my friend, this error is related to Virtual memory pressure and not physical memory pressure.

Even if you add 100 GB of RAM it...

As I said, a guess. I'd lower the max memory requirements for the three instances to a total of 6 GB (2 GB each) leaving 2 GB RAM for...

So, you are saying that the only two accounts/groups with sys admin rights to your server were the Builtin\Administrators and sa, correct? First, as a general rule, you shouldn't...

Okay, so when do I get everything else I asked you for, you know, the sample data, expected results based on said data? If you want help, you have...

What's wrong with just doing this:

SELECT CustomerID, CompanyName FROM Customers

A guess? You are overcommitting your memory. You probably should allocate more than 2 GB to each instance as that will total 6 GB and leave 2 GB...

The...

Do you have DAC enabled on the server? If not, you may want to enable it; if you do, good. If this happens again, you may want to...

Could you post the DDL for your DDL triggers? Maybe we'll see something you missed.

Florian Reischl (6/29/2009)

---

SET FUN ON

Or, a UNION ALL if you generally don't like functions in your SELECT clause.

SELECT ZIP + isnull('-' + PlusFour, '') AS FullZIP

FROM [Address]

...

Nuts (6/29/2009)

---

Table A

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[DrugA]

AS

SELECT year1, month1, Quarter,[Patient No.]

FROM MainTable AS a

WHERE ...

:hehe: