I wish that was true, right now I am stuck out side a VP office surrounded by Data analysts . I miss my cave. I want it back....

I keep going back and checking my windows account thinking they permissions aren't right but they look fine. Its not like I haven't done this before. All I...

Being from Central PA, DBA = Jack of all Trades

since I relocated to the Washington DC area, I am finding DBA is more strict a definition, but you have ...

were you able to learn anything about this topic?

--place comments here

And no one ever did

Check out this Blog:

http://ratecontrol.blogspot.com/2011/04/database-mirroring-with-transparent.html

What you describe sounds more like you need to implement a strong role based security model not TDE encryption as a solution to your problem.

I tried to do the following:

1) remove the references to the extra table from the XSD = didnt work

2) Change the name of the column in the XSD still tried...

I do not have an example of the xml to post, not allowed. The file is not large.

It organizes perfectly except on the 5th table that I Need to omit....

I agree questions have gotten worse and so have the answers and the resources.

I have to admitt I have hit many a brain freeze lately. I got...

It isn't so much as having to encrypt something right this minute as it is to compliance with a new organizational policy,

We were provided those scripts and told...

So to Clarify, I should be creating a new certificate 1st, Taking a backup, then If I need to replicate on other servers use the back up and that this...

I had the same quandry with the wording of the company policy. I believe that enabled just means the same thing as the PBM script.

Basically I think that ...

Did you ever find an answer?

I am looking for someting similar and I must not be searching correctly.

I was looking for either a T-SQL or WMI or even Powershell script that can scan a registry...