Then try something like this:

select top 1000 * FROM

(SELECT lc.email

l.leadid,

...

TS stands for Technical Specialist. The 'entry level' certification.

SG (1/29/2009)

---

So I tried this but am still getting duplicates - why?

select top 1000 * from (

select

...

Can you post the queries, the table schemas, the index definitions and the execution plans with that table as part of the query? (save as a .sqlplan file, zip and...

No. Not at all. That recommendation is give for TempDB and only for TempDB and only if you're...

If it was a deadlock, you'd be getting a different error.

Msg 1205, Level 13, State 45, Line 5

Transaction (Process ID 53) was deadlocked on lock resources with another process and...

A deadlock won't cause a job to hang. It would cause a job to fail. Are you sure you're getting deadlocks, and not regular blocking?

ScottPletcher (1/29/2009)

---

I never said it was doing a seek, I said it was using the index. It looked to me like SQL was scanning the non-clus index to get...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic645895-145-1.aspx

What I'd suggest is, instead of sending the mail direct from a trigger (which is usually a bad idea anyway), have the trigger write the info for the mails into...

Please create a new thread for a new question, don't just tag on to the end of an existing thread.

In addition, this is a repeat of a post tagged onto...

Sounds like you're trying to restore over an existing database. If this is a migration from MSDE to SQL 2005, why are you restoring over an existing database? You should...

sudhirbharti (1/29/2009)

---

SELECT @user-id = userid,

@OldCity= d.City

FROM deleted d

SELECT @NewCity =...

I wish!

I'm not?