Thanks a lot Jeff. This is a good solution for well formatted html. Thanks a lot again Jeff.

If these strings...

Thanks jeff. Yes I just need the string with no HTML tags. IF there is new line I do not need another line, but need one string for each...

thanks Jessie... In my desktop, I have SQL 2008 R2 installed and I can see Integration Services in the menu (it has Data Profiler View and Execute Package Utility). I...

thank u jessie for your response. Need to confirm couple of things.. sorry I am new to this...

To create/edit/deploy SSIS packages you will need to have BIDS (Business Intelligence ..etc)...

Hmm in that case you have to read the row which has column names and then parse..

I think the better way to do is... read first record from each...

Hi rhlangley your writeup and scripts are really good. I cannot thank you enough for your help. Thanks for the book names too.. I will certainly get one.

Lowell say if we encrypt the column of data in production and if we want to refresh dev environment using prod data how can we implement the same encryption/decryption in...

Thanks lowell.

when creating Symmetric key with Certification do I have to create certificate for every users who will access the data column?

thanks guys. I found this encrypting using ASCII characters, but I don't think this adds any security...

http://www.sql-server-helper.com/functions/string-encryption.aspx

Thanks Srikant have you used this method? What are the different db objects that I need to create?

Thanks,

Laura

Thanks lowell. Have you used symmetric encryption with certificate? What are the db objects I need to create to facilitate that? Thanks!

Laura

Lowell (8/1/2011)

---

these two links are my favorite introductions to...

Thanks lowell for your response. Actually I will be doing this on SQL 2005 and SQL 2008. I do not have to implement that on SQL 2000 as we will...

Lol final weeks are going on for summer classes in many schools 🙂