Gail, I had to create extra MDF's to deal with SGAM contention, so now I need to shrink the old file.

Bhuvnesh (10/3/2013)

---

IN two cases , size will not get reduced.

1) Shrink will not...

Thanks for everyone's help!

I modified the query so the columns will show if it is Arrived or In Transit, but the code works on my test... but not on my real data.

Error:

Msg 102,...

Man this is messy. Has MS fixed this in 2012? We are using 2005 and 2008.

This is as close and seems to work, now how would I show the Arrived .. In Transport. The columns are there.. Arrived first, and then In Transport, thanks to...

Thanks... yes this field is real simple.. just the code and description of the rail transport... So I tested the code on our data.. and it works great!

I used a CTE to cast the data... and it works, thanks for your help.... I was chasing the wrong rabbit.

;with Del_Ind as

(

SELECT Row_Number() Over(Partition by Purchasing_Doc_Num, Purchasing_Req_Item_Num...

Ok.. I guess the error I got was not due to the way I was doing it.. the test table I just created to post this worked.. so the data...

Erland Sommarskog (8/9/2013)

---

dwilliscp (8/9/2013)

---

Sorry should have added.. 64bit. Any change that would effect Disaster Recover, has to be done by the App Admin team. So I put in a request,...

GilaMonster (8/9/2013)

---

32 bit or 64 bit?

Have you enabled remote DAC? If not, you'll have to connect from the...

I am getting an error that DAC is not supported. I will...

Not yet.. still reviewing the posts.

Erland Sommarskog (8/8/2013)

---

If you run out of workers, this is likely to be due to one of the following (or a combination thereof):

1) There are simply too many active users.

2)...

When...