The command, sp_encryption help, key_name,
display_cols, displays only encrypted
columns in the system database and local temporary database that
are owned by the instance where the command is run. This command
skips the local temporary database owned by a remote instance and
displays a message similar to:
Local temporary database '<database name>' is skipped for this operation. The database is accessible from the owner instance '<instance name>' only. Execute this procedure on ASE instance '<instance name>' to see any columns encrypted with key '<keyname>' on database '<database name>'.
You must run the command on the remote instance to display the remote instance’s columns encrypted with the specified key on local temporary database.
