Troubleshooting: Some objects are displayed as encrypted even it is known that they are non-encrypted.

LINKS

General

Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff (Data)
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Report
Apex SQL Script

Troubleshooting Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly. Click Here for more info.

FAQs

Quick answers to common questions. Click Here for more info.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.

Online Documentation

All of our help files for download or convenient viewing online. Click Here for more info.

Videos

Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.

Troubleshooting

Troubleshooting and Known issues with Apex SQL Tools

Some objects are displayed as encrypted even it is known that they are non-encrypted.

When browsing DDL script of the objects some of them reported as being encrypted though they are known to be non-encrypted.

CAUSE
The cause might be that you have connected to SQL Server 2005 database with non-database owner permissions and some objects information becomes un-available for you.
For example, you are connecting to the target database with the read-only permissions:

You don't have privileges enough to access all meta-information that should be requested to specify the object properties, and warning message is displayed:

After comparison was finished the generated DDL script for existing non-encrypted database object is displayed as encrypted:

LAST REVIEW

17 September 2007 Date of Last Review

Labels: ApexSQL Diff

posted by Irene Sanford on Friday, July 20, 2007

0 Comments: