• Under Options, ensure that "Decrypt Encrypted objects on 2005 and 2008 databases" is checked. Otherwise you will get "-- Text was encrypted" .