What's the goal? Is it important to drop the column, or are you only looking to change the PRIMARY KEY constraint? If the latter, you don't have to...

sqlstuff (12/29/2008)

---

Matt

You are right but it's a matter of displaying. The question need not be repeated. The FORUM column can have more than one entries.....or a new column can be...

Or - make this an INSTEAD OF trigger and check the stuff BEFORE you insert it. that way again, no rollback (since nothing has happened yet). Instead -...

Then you will not be able to deny the DBA access to the data. He sets up the encryption, after all.

That being said - here's the microsoft white Paper...

Jeff Moden (12/28/2008)

---

Thanks, Chris. Yeah, I know it looks unusual... WITH is the only place where a semi-colon is actually required before something and since I don't use semi-colons...

The highly similar post is located here:

http://www.sqlservercentral.com/Forums/Topic626691-359-1.aspx

If you don't want the DBA OR the client to understand the values - then I'd recommend you encrypt the value using something external (say, in .NET before it even...

sqlstuff (12/29/2008)

---

To sum it up...broad headings with multiple sub-headings for a 'primary post' and same option for 'secondary post'. The secondary post can be limited to 2 options to start...

Matt Miller (12/29/2008)

---

Jeff Moden (12/26/2008)

---

Just bought a nice new Calypso Cruiser (bicycle)... 7 speeds......

The big problem is that you're leaving the question so very undefined, it's hard to answer it. Knowing what kind of encryption you need, figuring out whether the built-in...

That's ok Noel - Chris harshman already posted something similar on the OTHER thread the OP started on the same topic....:

http://www.sqlservercentral.com/Forums/Topic626424-360-1.aspx

enjoy!

Now - keep in mind this: should you TRY to modify the code listed above, and you get stuck somewhere, and you were to come back and post what you...

I also don't have the time to plow through everything you've posted. That being said - if you're POSITIVE this is the very best way to do this, you...

Keep in mind you could "return rows" of data without ever accessing any other table. Also - just because you might select rows from a table while in a...

Bob - you must be a SERIOUS mindreader. Coming up with the right code that answer the question (consisting only of Can we?......How>) - that's truly impressive.

Say - do...