Lynn Pettis (3/22/2014)

---

Just a guess, but I would think as long as you have the certificate used to encrypt the database with TDE it should not matter what backup software...

Well, today is going to be a big day for the wife and I, almost as big as when I switched jobs...

Today we meet with the builders to go over...

OK, I've got a thought then. It looks like, from reading the BOL on tokens, that they are for TSQL job steps. Try prefixing the command with the...

Couple questions about this:

1. Can you execute any other CMDEXEC steps? Ignore what you're trying to do, try something simple first, like "DIR > c:\temp\dirlist.txt" and see if...

GilaMonster (3/10/2014)

---

Jack Corbett (3/10/2014)

---

My job title is Data Software Development Leader. I'll be doing a lot of design and architecture work. I'm going to kind...

SQLDCH (2/28/2014)

---

I'd love to see a reboot of the Barsoom (John Carter) series by Edgar Rice Burroughs. Disney already made an attempt, but it was pretty bad, leaving out...

Didn't think about comic adaptations, although being a Marvel fan for a long time, I'm quite happy right now...

Now, for an interesting idea for a comic movie...

Batman vs Aliens

Batman vs...

:w00t::cool:

Another book I wouldn't mind seeing made into a movie would be Fallen Angels by Niven / Pournelle / Barnes (I think...

Jim P. (2/28/2014)

---

jasona.work (2/28/2014)

---

I'd love to see a couple (OK, a lot) of books made into movies (heck some might be better as a mini-series on TV)

The Posleen War series...

I'd love to see a couple (OK, a lot) of books made into movies (heck some might be better as a mini-series on TV)

Ringworld - Larry Niven

Last Centurion - John...

Markus (2/20/2014)

---

I RDP into them quite often. Especially if it is late at night and we have an outage window to do major things like Service Packs or a...

Man, it got quiet in here...

Is the watercooler empty or something?

Gazareth has it right. The space available does NOT include the LDF / Log file space. If you add up the space available + space used results for...

Brandie,

I've always divided by 1024 when going from KB to MB.

I just tried your query against one of my DBs, replacing:

(FILEPROPERTY(a.name,'SpaceUsed') * 8) / 128.0000 AS MBSpaceUsed,

with

(FILEPROPERTY(a.name,'SpaceUsed') * 8) /...

7474 pages currently, according to sys.dm_db_index_physical_stats. The...