Ah, roger... For the load it might make sense to add a trigger to capture the IDs of the updated or changed records and then use that to handle the...

True, you can't pass alternate credentials. This is why I would often create a proxy and the process would run in that context.

CEWII

Ah, my bad, 50B. 700GB is a lot but no completely outrageous.. 175GB is big but not outrageous..

Those are really narrow rows.. Makes sense how 50B is...

No, you can't do this.

You mention moving them back into database A, they aren't and were never part of that database and even if they were they stil...

At that bank I was talking about the developers didn't have access to the production backups.

I think we'll just have to agree to disagree.

CEWII

The windows 7 analogy is a good one. An additional point still using that analogy would be that you wanted to use bitlocker but basic doesn't have that..

There are...

For year only I wouldnt use a calendar control.. From the interface perspective I'd use a drop-down.

This is a case where I would likely use a smallint to store...

You are very welcome.

CEWII

Steve Jones - SSC Editor (5/31/2011)

---

Fair points, Elliot and it's one of the reasons I'm annoyed that TDE isn't in other editions. This is great for protecting the data at...

Yes it would have all been written to table A, to control precedence click on the first container, you are gonna see a little green arrow pop out at the...

Does the box that comes up say "The sensitive data in package" or "The package "packagename" is encrypted"?

The first one you can probably get around, the later one you are...

You could call the guy and see if he'll tell you. If he doesn't you could always threaten him with a lawsuit, i hate to be that guy but...

The suggestion of the previous poster only handles the BIDS environment.. It is not honored on the server..

What version of SQL are you using, if its 2008 or higher...

Do these containers run at the same time? If so you are likely to end up with blocking. If not then you can probably reference the table from...

I would actually warn against mapping drives if there is any way to prevent it. It is far better to use UNC paths. In my experieince unless I...