I know this question is 2 years old, but thought I would answer it anyway.

I don't think you can 'ignore' the namespace, and your best bet may be to use...

Very cool solutions. Great article.

Toby Harman (6/26/2012)

---

You have two answers that are potentially correct here.

None, and None unless the rest of the command specifies one.

Shame I picked the wrong one!

Edit: I stand corrected. The...

Agreed. The question is poorly constructed, with part...

sp_linkedservers

You were right in that the syntax requires the preceding line to be terminated with a semi-colon. The way it is presented implies the line containing THROW must lead with...

I think a text box inside of a list object may give you the solution. Have you googled this at all? I found a couple of links that...

set @p1.modify('replace value of (/Data/Datas/Item[@primaryKeyId = ("12")]/ExtraDetails/Column/@salary)[1] with 1200')

set @p1.modify('replace value of (/Data/Datas/Item[@primaryKeyId = ("14")]/ExtraDetails/Column/@salary)[1] with 1200')

Yes. Can you show me the complete XML string, including the namespace?

There is no way to override that security feature. You could put an application between whatever program the users are using to log into SQL Server with, and have...

asm1212 (5/30/2012)

---

Apparently I need a crash course on encryption...This gets really confusing...

I am not sure how I will move forward but I will somehow someway! lol

Thanks to all that have...

Actually, it seems like your immediate error is resulting from not converting the result of the KEY_GUID() function. Convert the value to VARCHAR:

OPEN SYMMETRIC KEY Key_01

DECRYPTION BY CERTIFICATE DatabaseA01

UPDATE...

Ok I ran the above statement when I was trying to figure out how to decrypt the existing values before I posted on here...But I kept getting an error...however, I...

She can use her own copy of Visual Studio, and develop reports locally, and connect to the production Reporting Services server to upload the new reports.

This statement simply encrypts EXISTING SSNs:

OPEN SYMMETRIC KEY Key_01

DECRYPTION BY CERTIFICATE DatabaseA01

UPDATE dbo.TableA

SET SSN = ENCRYPTBYKEY(KEY_GUID('Key_01'), SSN)

CLOSE SYMMETRIC KEY Key_01

If new records are being encrypted as they are added, you...