Can I save my projects and options for future reference?
Yes. If you save your project - your option will be saved
If you change your project Source and Destination - your options will be reset to default
I'm having display problems because of the large number of objects. Can I group and sort them?
ApexSQL Clean identified un-referenced objects in my database. How can I safely remove these objects?
Use the Clean script Generation wizard. It will generate a script which will automatically remove all selected un-referenced objects
Can ApexSQL Clean show which columns participate in a dependency relationship?
Yes. ApexSQL Clean can show column level dependencies
Can ApexSQL Clean identify dependencies for dynamic SQL in objects like stored procedures and functions?
Can ApexSQL Clean find external references to objects in different databases?
Yes, select the referenced database as the external database. The external database has to be on the same SQL Server instance
Can I analyze my .NET projects or other client code (Delphi, C++, ASP, etc.) for database?
Yes .NET projects or other client code (Delphi, C++, ASP, etc.) can be analyzed
I would like my searches for objects in source code files to be case sensitive. How can I do that?
Use the Match case option. Note that this affects only search within client application source code files. Searches within SQL Server objects are NOT affected by this setting
Can I see a visual representation of the dependency analysis?
Yes. ApexSQL Clean has a powerful Dependency viewer based on its own parsing technology
What export/save options do I have in the Dependency viewer?
Dependency viewer image can be saved to a variety formats such as .jpg, .bmp, .gif, or .png. It can also be printed directly
Can I change the look and appearance of objects in the Dependency viewer?
Command line interfacer
I have a large and busy database I want to check for references. But I don’t want any unnecessary workload on that database during peak usage hours. Can I schedule a job to start the dependency analysis in off-peak hours?
Yes, use ApexSQL Clean command line interface. Create a *.bat file and schedule its execution as a SQL Server job or a Windows task
The command line operation of ApexSQL Clean requires that I provide a bit-wise value for determining which object types are to be documented. How can I determine that value?
The bit-wise value for object type selection is displayed in Object Filter in ApexSQL Clean GUI