Adam Hills (7/1/2011)

---

This looks like...

sturner (7/1/2011)

---

Freddie-304292 (7/1/2011)

---

But I know I wouldn't fit in with any company that expected people to come in for a full day interview, and would turn them down flat. Remember...

Fine then, one billboard coming up to announce it elsewhere.

EDIT: Sorry, that was too big.

You don't.

It's not built to be backwards compatible once you've moved a database to a higher engine.

Rescript all the components, run said scripts on previous version, create SSIS package of...

Jeff Moden (6/30/2011)

---

I don't know if it'll make people feel any better about the "Quirky Update" but Tom Thompson and Paul White added a couple of things to it to...

Apparently so is your log file. Hrm.

Out of curiousity, can you pull the VLF information for us?

DBCC LOGINFO('MyDB')

I'm not sure it'll help but...

bubs (6/30/2011)

---

By removing the Integrated Security=false and adding in Trusted_Connection=yes resolved the connection issue.

That seems to all be working fine now. Now on to some encryption questions.. 🙂

There are definitely...

hwells (6/30/2011)

---

Craig, would...

You can't guarantee the order of events in a query without FORCE ORDER, so what's happening is something is trying to get through the convert that you eventually weed out...

What Elliott mentions about being the hired gun is important here. You need to be careful about your phrasing. "This obviously grew out of its original scope." vs....

djackson 22568 (6/30/2011)

---

Not only that, but employers tend to talk about valuing teamwork, but do everything they can to destroy it. Best example - everyone gets the same raise,...

YSLGuru (6/30/2011)

---

If one is trying to produce output that includes a running total or running balance and the "quirky Update" method from Jeff Moden is not an option and you're...

Adam Hills (6/29/2011)

---

Unfortunately, we haven't got any backup agents/programs installed, so Craig is correct. I'll take a log at the drive tomorrow and let you know if I can find...

Adam Hills (6/29/2011)

---

I can get a backup of the dbs from the program files/sql server/data folder or do you mean the ntbackup?

I have that on a network storage device which...

Just a 'is it plugged in' kind of question first:

What recovery mode is the...