Steve,

I'm talking about the key below..

IF NOT EXISTS

(SELECT * FROM sys.symmetric_keys WHERE symmetric_key_id = 101)

CREATE MASTER KEY ENCRYPTION BY

PASSWORD = '*************************************************'

GO

Is this different from SMK? Do I need to find the SMK for Prod db and run it on test db server?

Thanks a lot