For synonyms constructed on tables, no changes are required to the synonym to reflect changes in columns on the underlying table. The synonyms adjust automatically...

I am using version 8.1 . There is a "Filter Setup" button that has a funnel icon. If you click this, it will show what...

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

Red Gate's SQL Compare will un-encrypt an "encrypted" stored procedure.

1) Start SQL Compare.

2) Specify the database , containing the encrypted procedure(s) , as both the source and...