OK, I think we've come as far as we can without your providing any table DDL and sample data. Please post the former in terms of CREATE TABLE statements,...

I would advise against doing that, since it would make the condition...

Something like this?

SELECT <column list>

FROM MyTable

EXCEPT

SELECT <column list>

FROM MyTable

WHERE PORT_CD = 'BEZEE'

AND ARRIVAL_SCHEDULE_DT < dateadd(mm, 3, getdate())

John

You're probably going to have to do a bit of trial and error. Expand the Errors and Warnings category, and hover your cursor over each event for a description....

I'm sorry, but I don't understand what you're trying to do. Why do you think you need to use a variable, and why do you set a value for...

I don't understand your question. What is ALL ERRORS? If you want to capture failed logins, do as I suggested. Are you saying you need to capture...

I think you're looking for the Audit Login Failed event, under Security.

John

Yes, I am, and to be honest, I'd be surprised if I saw what you're seeing. I wish I knew how you do it!

John

I've taken the liberty of tweaking so that it doesn't get fooled by non-alpha characters.

Code is posted as an attachment since it timed out when I tried to post in-line.

John

I get the same results for both examples. I can't see how putting in a GO will make any difference.

John

Vijay

Does your database have a case-sensitive collation?

John

Are you sure Example 1 works? This is what I get:

Value Seq

1011

1011

1021

1021

1021

1022

1031

1041

1041

1041

John

"It won't work" is a little vague. Please post any error messages you get, or show how the results you get differ from those you expect. Table DDL...

When you say you couldn't find anything in SQLAGENT.OUT, do you mean you couldn't find SQLAGENT.OUT at all? If that's the case, the reason it's failing to start is...

This should help:

http://msdn.microsoft.com/en-us/library/ms174979.aspx

Let us know if there's anything in particular that you don't understand.

John