• I've now managed to do this. I'm planning on writing an accurate on it for sql server central - hopefully Over the course of the next week or so).

    a key part in the process is restoring the encryption keys...

    here's another thread , to keep an eye on as there are a few others interested and I'll let you all know, once I written the article.

    http://www.sqlservercentral.com/Forums/Topic843493-147-1.aspx#bm858517

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)