The message says it all: buy a license.

I think your issue is the same as your other post:

http://www.sqlservercentral.com/Forums/FindPost1234607.aspx

Do you have a fulltext index for TEXT? That would speed up things a lot.

SQLLite works on most portable devices.

Page Life Expectancy.

It's one of the easiest methods to detect memory pressure.

Here's a good article on the subject:

http://www.sqlskills.com/blogs/jonathan/post/Finding-what-queries-in-the-plan-cache-use-a-specific-index.aspx (Read the paragraph "What’s Wrong about Page Life Expectancy >= 300?")

Thanks for the feedback.

Glad you sorted it out.

You mean that the SQL Server service is not showing in the Cluster resources?

I guess you didn't install it as a cluster service, then.

Try issuing this:

SELECT SERVERPROPERTY('IsClustered')

If it returns 0,...

Definitely an application error.

App seems to complain about empty connection type. Debug the application.

JimS-Indy (1/11/2012)

---

My client uses SQL Server 2005, though I have SSMA 2008 available to me.

I want to send an email with a caption on it ('Red Cross Rescue Team...

Oracle linked server? Hmmm...

How is the provider loaded? In process or out of process? In process load could definitely crash the service if the provider leaks memory.

Even if regular connections...

No, wait: you mean you have a column named "...

Another great read.

I must have missed it when you first published it.

Thanks a lot!

SQL Kiwi (1/11/2012)

---

http://weblogs.sqlteam.com/dang/archive/2009/01/31/UPSERT-Race-Condition-With-MERGE.aspx

You broke my code! That doesn't allow me to insert a NULL...

Rewritten for mere mortals (like myself):

CREATE TABLE myTable (

pKey INT IDENTITY(1,1) PRIMARY KEY,

CODE VARCHAR(10)

);

DECLARE @MYCODE VARCHAR(10) = 'MYCODE';

DECLARE @ID int = NULL;

DECLARE @OUTPUT TABLE (ID int);

WITH TestedValue (MyCode) AS (

SELECT...

Another option: use a linked server.