thanks for the update. Any resolution steps others could try?

BTW, an interesting read here: http://stratechery.com/2013/why-microsofts-reorganization-is-a-bad-idea/

dg81328 (7/14/2013)

---

There are a few things to consider about Microsoft's reorg that put the thing in perspective.

1) they do this every few years

2) it does not change the patterns that...

hany.helmy (7/14/2013)

---

In the explanation it was mentioned the following: "The DEK is inside the backup", to be honest I am not an expert of (Transparent Data Encryption), but I am...

L' Eomot Inversé (7/12/2013)

---

Personally I find it very hard to understand why, some years ago, the USA government/administration decided to instill into operatives in its federal services an attitude to...

I'm not sure what you mean about insecure if you have the cert without the password. You could have a blank password, but in that case you'd technically have the...

Sean Lange (7/12/2013)

---

Greg Edwards-268690 (7/12/2013)

---

Sean Lange (7/12/2013)

---

Steve Jones - SSC Editor (7/11/2013)

---

I renewed my passport last year. There still was expedited service, but I didn't choose it. Got mine in...

Use the import wizard to get you started.

Or look through the Stairway here. It does an incremental load that might help

http://www.sqlservercentral.com/stairway/72494/

It's worded poorly in BOL.

Essentially on the source you:

- create master key (protected by SMK) in master.

- create cert, protected by DMK (master key).

- you backup the cert, decrypting it...

no need to apologize and glad you got it figured out.

you've got the right solution. Move backups, restore.

Also, script out logins (sp_helprevlogin) and move those. Watch out for linked servers,...

I believe you need to drop and reconfigure replication with a new distributor. You should have scripted out replication as soon as it's set up since problems can result in...

the thing to do, IMHO, is have a series of passes in the data, with a few procs/functions, that handle different items. This one posted looks good, but I bet...

Good for you.

you might think about scanning a folder in the package for .bak files, working out the latest one, and then grabbing the name for use in the...

The case is that you don't have any instance logins, only contained ones in your database. You can migrate all your users (windows are easy) to contained, and then you...

You should get an error.

AFAIK, Windows 7 is not an acceptable OS for SQL 2008 R2 enterprise, or any version.

http://msdn.microsoft.com/en-us/library/ms143506(v=SQL.105).aspx

This is only supposed to run on Server OSes.