RBarryYoung (9/12/2012)

GSquared (9/12/2012)

RBarryYoung (9/12/2012)

Well, I may have over-reacted. I am trying to an IRS download directory (http://www.irs.gov/pub/irs-soi) but a I cannot get a connection. I don't think it...

Montego Bay

Wherewolf?

Thanks Lynn.

😉

hunchback

Thanks. I guess what was throwing me was, I would have expected to still be able to logon to the SQL using one of the existing local Windows users.

Jason

Have you considered using Powershell? I'm presuming you have it on the server, so you could craft a Powershell script to grab the file(s), then unzip them. Once...

Ah, the feeling you get when you do something for yourself, from scratch, without finding someone elses' code to use...

Even if it is something that a seasoned DBA (not me!)...

I would have two dream machines, one for work use, and one for personal use...

My work box would just be a desktop, support 2+ monitors, LOTS of RAM and a...

A DOS batch file run with Windows Task Scheduler.

Here's one I came up with, it does require that you have pkzip / pkzipc / pkunzip somewhere in your path, though....

Once more, thank you. I hadn't thought about what would be required to restore the DB (and still be able to access the encrypted data) until after your post.

With...

OK, so Express can for sure encrypt by passphrase, so I'm expecting it will work by certificate as well.

Yup, it does work by certificates as well...

Once more, thank you!

Jason A.

Thanks! I always forget to check BOL...

I just completed loading up SQL Express on my PC, and will be testing this out.

Jason A.

Lions

My stand on it would be, who's going to be supporting the configuration?

If it's you, and you aren't familiar with / comfortable with setting up VMWare and managing it (I'd...