We had this discussion as our GIS Tech was headed out to the Tail of the Dragon for a road rally. Turns out GIS is the one place we don't...

Ed Wagner (2/26/2016)

---

TheSQLGuru (2/25/2016)

---

Please post even it if is "overly...

I have spent some time going back and forth with MS Support, convinced them a workaround of "copy the data to another table in another database then copy it back"...

Jon.Morisi (2/26/2016)

---

2005 to 2012 is greater than 2 major versions. Try this, 2005 to 2008 or 08R2, up the compatibility level, new bak, then restore to 2012.

Basically "90 compatibility...

I tried the detach/attach thing. Same problem. I'll call MS and post a solution if it's not overly embarrassing.

Steve

Yeah - the dbcc checkdb is what brought the inconsistency to light. I've restored the database to a 2008 server without issue, but the same backup, restored to a 2012...

Odd is right. This is a third party database. We have several instances of this database (for different clients on our end). I just tried this process with a different...

I've enjoyed the Nathan Lowell stuff too - d/l them as podio books years ago. Not sure if it went as far as Captain back then though - I'll have...

But is there a practical difference between

(field1 + field2) [alias1]

and

[alias1] = (field1 + field2)

?

I've (almost) always used 'AS' as well. I was handed this query to work on though and the first thing I need to do is clean it up so I...

The only errors in there event log were from Exchange, which is apparently loaded on that server, but not used.

Apparently time heals all wounds. I got back to the customer last night and the service had managed to finally stop. I was then able to change it to manual...

I'm not quite following. If I hard boot (and I'll wear steel toed boots when I visit it tonight) the server, log in as the administrator, jump into services it...

Yup. That works too. Time is about 1 second against the production table.

Of the four solutions, it is the only one that returns bookings with no releases. ...

Thanks all,

All three solutions work great and returned the same results (once I reconciled the selection). The only difference in run time seems to be that the first solution...