As a test, add a TOP 2270 in you're select statement, see if it works?

If you confirm that you're data is in fact healty and normal, it's a bit strange...

If you have installed just the SSMS Basic Tools (such as from Express Advanced, or by not selecting SSMS advanced during setup), you will not be able to use Job...

It's sometimes difficult getting the Manager to pay for training....especially when based on a client site.

Every individuals career lenght and training path is essentially linked to the duration of the...

glad to be of some help.

Try....

Select * from dbo.DW_T_EC_JOB_TEMP t

where

t.EC_STEP_ID not in

(select j.EC_STEP_ID from DW_T_EC_JOB j

INNER JOIN DW_T_EC_JOB_TEMP t

ON

j.EC_STEP_ID = t.EC_STEP_ID)

--instead of--

--where (dbo.DW_T_EC_JOB.EC_STEP_ID = dbo.DW_T_EC_JOB_TEMP.EC_STEP_ID))

This is my attempt to assist you 😀

DECLARE

@int date,

@idate datetime

SET @int = (SELECT CONVERT(date,getdate()))

SET @iDate = (SELECT CONVERT(datetime, @int))

SELECT @int AS Initial_Conversion, @idate AS Result

--or try CAST & convert

SELECT...

Now that you are on 2k8, use the excellent** new Activity Monitor to see which processes are taking long AND why?

check your SQL logs for any errors or infor messages...

run it 5 times each, and see if there is really a one second difference...each time..

Call me a bit too serious, but I wouldnt take my eyes off the screen if I were you.

The mere fact that you "expect" something to fail, says a lot.

Rather...

I wouldnt say YES, or NO...but....

Depends on youre host (let's say ESX) you will be sharing resources with other...

NP, glad it helped.

I'm also a bit confused Paul, just took a shot and hoped he meant, SQL notifications, to an outlook/exhange mailbox.

If not: this question doesnt make...

I dont specifically for success/failure, but a log is kept.

There is a History tab on each Operator in SSMS 2005, which indicates most recent notification attempts.

select @@version

youre first post

youre second post

So how can i get this...