Paul White (1/26/2010)

---

Jeffrey Williams-493691 (1/26/2010)

---

At least it is an identity - I remember not too long ago he was just a period. A dot, nothing more - not really...

Nice suggestion. I will test this myself and post back with results.

It depends for us. If there is a vulnerability covered by it then yes. Otherwise, we tend to wait. There are the normal patches and then service...

Thanks

Jeffrey Williams-493691 (1/26/2010)

---

CirquedeSQLeil (1/26/2010)

---

Paul White (1/26/2010)

---

Oh so The Dixie Flatline *is* Bob! I missed the transition somewhere...d'oh!

Thanks for...

The basis of the question was to direct which answer to provide. If data load, then an ETL type process. If it was just a bunch of sql...

What...

Fraggle-805517 (1/26/2010)

---

You are correct there.

However, I am still curious to know the answer to the question. I would rather have the 15 GB database on the server...

You encourager of laziness and evil 😀

Fraggle-805517 (1/26/2010)

---

It can be done easily through SMO. We actually have an in house process that will go through and encrypt or decrypt and entire database of procs,triggers, and...

Backing up the database will only backup the used portion of the data file and then restore that portion. The extra time to process is due to creating the...

Fraggle is spot on. Just assign your date to the variable and then re-use the variable throughout the code.

Jeff Moden (1/26/2010)

---

Just curious, Jason. Why would data loads be so different as to require such a large script? 200 MB seems high for such a thing. ...

Here is a commercial product that may help:

http://www.devlib.net/decryptsql.htm

and another site that offers some information

http://www.sql-shield.com/decrypt-stored-procedure.html

NP.

If you have the Primary already split into multiple files - no problems at all. I think you would have no problem being able to transfer the data within...