I suggest that you replace these rows

EXEC dbo.s_DropTempDBTable '#Error';

GO

with this

IF OBJECT_ID('tempdb..#error', 'U') IS NOT NULL

DROP TABLE #error;

Out of interest ... Temp tables get dropped automatically by the system ... why are you trying to do this manually?

Eirikur Eiriksson (10/26/2016)

---

homebrew01 (10/26/2016)

---

I'm considering upgrading our production server from 2005, at the same time we upgrade servers. I have not kept up on the most recent versions. No specific...

Any clairvoyants here today?

Good luck with that, as you've given us neither the text nor the expression.

mcfarlandparkway (10/26/2016)

---

I have a table of ssisconfig table where I stored all the connection strings with a type column.

In the package I took execute sql task and queried with ssis...

dramaqueen (10/26/2016)

---

I am currently looking at identifying duplicate names and looking for behavior patters. A duplicate in this case is very high level and there is risk involved as you...

BWFC (10/26/2016)

---

jasona.work (10/26/2016)

---

Brandie Tarvin (10/26/2016)

---

jasona.work (10/26/2016)

---

Phil Parkin (10/26/2016)

---

HanShi (10/26/2016)

---

BLOB_EATER (10/26/2016)

---

I liked Eric's response - "get a job...

kesavan.rv (10/26/2016)

---

Hi Friends,

All off sudden in my PROD SQL server memory was reduced to zero(As the minimum memory was set to 0).

Is there any way to find which one...

Ricky Valencia (10/26/2016)

---

Our client described to us how they wanted to migrate their data from one datacentre to another datacentre as follows:

•An application will generate csv files to a folder...

+1, this is the...

HanShi (10/26/2016)

---

The problem is that they probably...

Luis Cazares (10/25/2016)

---

Phil Parkin (10/25/2016)

---

Luis Cazares (10/25/2016)

---

However, the OUTPUT clause will generate an empty result set when no rows are updated, so that should work.

And with a single statement and...

Luis Cazares (10/25/2016)

---

However, the OUTPUT clause will generate an empty result set when no rows are updated, so that should work.

And with a single statement and the error handling just...

And I missed that. Definitely need the ORDER BY.