Take out the line with the GO just before the EXEC command. There appears to be an extraneous character after the GO, plus it ends the batch and your...

rupes0610 (4/4/2012)

---

I need to sort all the rows and then select the first 15 with the smallest height difference. Your method selects the first 15 and then sorts them....

Definately a good question.

Well, apparently we can't accept the restrictions he has to work under on this project. ...

rupes0610 (4/4/2012)

---

My query is not working - issue happens when I add the last WHERE clause. Otherwise it works fine. I need to get sort the rows before...

Why is it people ask if you have had a similar problem, then disagree with you when you have and tell them what was happening?

Tiazi (4/4/2012)

---

Correct we are writing it to a DFS.

The avg duration for the job to complete successfully while compression is off is about 5 hours.

When compression is on (and the...

ColdCoffee (4/4/2012)

---

Jeff Moden (4/4/2012)

---

Boy, are...

Please post the code for the procedure and the two functions.

Email sent, but I may not hear anything back until tomorrow. I will keep you posted.

Also, if you have space on the server, you may want to consider backing up locally then moving it to the network share.

Tiazi (4/4/2012)

---

Failed: (-1073548784) Executing the query "BACKUP DATABASE [DATABASENAME] TO DISK = N'\\\\path..."

failed with the following error: "The operating system returned the error '87

(failed to retrieve text for...

Not me, in fact i think I'll stay out of this one.

Welsh Corgi (4/4/2012)

---

ok, I would probably have the Database in Full Recovery but change it to Simple before the load and change it back to Full then perform a complete...

Welsh Corgi (4/4/2012)

---

Lynn Pettis (4/4/2012)

---

Still need to run t-log backups or you could run out of disk space as the log...