Hi ROHIT,

One thing you need to do is specify the IDENTITY_VALUE and KEY_SOURCE options in your CREATE SYMMETRIC KEY statement. By not specifying these SQL Server generated a random...

Hi ROHIT,

There's no one-size-fits-all script for this. The basic steps are:

1. Back up...

Lucky,

I sent you an email with a modified sample script. Based on what you sent me, you need to modify your BACKUP CERTIFICATE statement slightly to backup the certificate private...

luckysql.kinda (8/25/2009)

---

Hello Mike,

Thanks for your help.

When I use following command as per Sarab's response, I get following information:

RESTORE SERVICE MASTER KEY FROM FILE = 'D:\Database Backup\smk.dat'

DECRYPTION BY PASSWORD =...

luckysql.kinda (8/24/2009)

---

Thanks Mike C for this information but still I am not able to retrieve my data. I was able to take the backup of master key and certificate to...

Hi Lucky,

I just got out of a meeting and saw your messages. I have a question for you -- are you encrypting the data in your database with a...

Hi Barry, thanks for the props 🙂 Gail, don't be so modest 🙂

I think the most important thing for the OP to do is to make a backup of...

The question was asked if they had a backup of the database with DMK and certificate. So the OP...

Before you do anything further with this database, immediately take a backup and store it somewhere.

Next restore the backup database to a different database and immediately try to backup the...

derek (7/24/2009)

---

I am perhaps loosing my mind, but the conclusion says code can be downloaded from the link above. But the only link I can find is to http://www.codeplex.com/irony, not...

cghersi (7/15/2009)

---

Dear Michael,

first of all, thank you very much for your articles, always very interesting for me.

Let's talk about your article related to the FTS features of SQL server (Google-like...

rivantsov (6/11/2009)

---

Hi folks

this is Roman, Irony developer

Just wanted to let everybody know that I've refactored SearchGrammar to work with latest version of Irony and added it to Sample grammars in...

james.spibey (3/30/2009)

---

Hi Mike,

Thanks for responding. Unfortunately that didn't seem to do it. I notice that there is an explicit check for the "-" character in the "AndExpression" case statement in...

outatime (6/1/2009)

---

I'm using this in my current project and it's working great. Thanks for taking time to put together a nice article we can all follow!

My site is used...

Eric Inman (7/4/2009)

---

Mike C (7/4/2009)

---

If you're interested in guaranteeing data stored in the database is valid you have to use the database engine to check it, just like any other...