What are the minimum Windows permissions required to install and use ApexSQL Complete?
What are the minimum SQL Server permissions required to use ApexSQL Complete?
The minimum permissions required to compare SQL objects are:
- Public role membership
- VIEW ANY DEFINITION on the SQL instance the code will be executed on
Does the add-in support encrypted objects?
Yes, the add-in fully supports encrypted objects including auto-completing their names, accessing their parameters and displaying their structure
Is it possible to disable the add-in completely?
Yes. To do so, click Disable auto-complete in the ApexSQL Complete menu
Can I use another key to insert an item from the auto-complete list?
In the ApexSQL Complete menu, click Options and navigate to the Inserts tab. To specify which keys to be used as insertion keys, select the checkbox next to the displayed key
Can I set my own aliases?
Yes. In the ApexSQL Complete menu, click Options and navigate to the Aliases tab where you can specify a custom alias for each object from all available SQL Server instances and databases
Can I control the formatting of the auto-completed code?
In the ApexSQL Complete menu, click Options and navigate to the General tab. The automatically inserted keyword's case can be specified there. For more formatting and refactoring options, please see the ApexSQL Refactor product page
Can I control when the auto-complete list will pop-up?
In the ApexSQL Complete menu, click Options and navigate to the Hints tab. To specify the scenarios in which you do not want auto-complete to appear, simply deselect the appropriate checkboxes
How do I invoke auto-complete manually?
You can invoke auto-complete at any time by pressing Ctrl+Space
How can I navigate through auto-complete list?
Use the Up/Down keys or the mouse wheel to scroll through the auto-complete list
How can I improve the tool's performance?
In the ApexSQL Complete menu, click Refresh Cache to ensure that the auto-complete cache contains the latest database schema
What are the default keyboard shortcuts?
To see or set keyboard shortcuts, go to Options->Shortcuts tab
- Create snippet Ctrl+Alt+T
- Enable auto-complete Ctrl +Shift+A
- Executed queries Ctrl+Q, Ctrl+E
- Go to object Ctrl+Alt+Y
- Insert snippet Ctrl+Shift+Alt+N
- Refresh cache Ctrl +Shift+ Alt +l
- Tab navigation Ctrl+Q, Ctrl+T
- Invoke the hint-list Ctrl+Space
How do I get the updates?
To get updates, navigate to the Resources->Get updates. You can also check the website for new versions and download directly.
How to see the version of add-in?
To see version of add-in, go to the Resources->About. The version will be shown below the add-in name (e.g. 2016.03.0090). Click here for more information.
How to turn off the ApexSQL auto-updater
For more information, visit this page.
SQL Server support
Which SQL Server versions are supported?
Support is provided for SQL Server 2016, 2014, 2012, 2008 and 2005
What SQL Server Management Studio versions does ApexSQL Complete integrate in?
Microsoft SQL Server Management Studio 2016, 2014, and 2012.
You can use full-featured SQL Server Management Studio 2016 for free. Click here
What SQL Server editions are supported?
The add-in supports SQL Server 2016, 2014, 2012, 2008, and 2005 editions
Does ApexSQL Complete support SQL Azure?
Yes. ApexSQL Complete fully supports SQL Azure
Can all ApexSQL add-ins co-exist in a single SQL Server Management Studio instance?
The add-in can be used directly from SSMS and Visual Studio alongside any other ApexSQL add-in
I have multiple SQL Server versions. Can the add-in run on all of them?
Yes. Select the SQL Server Management Studio versions the add-in should be integrated in during its installation process
Visual Studio support
Does ApexSQL Complete support Visual Studio 2015?
Yes. It fully integrates with Visual Studio 2015
What Visual Studio version does the add-in support?
Support is offered for Visual Studio 2015, 2013, 2012, and 2010
Can the add-in run on multiple versions of Visual Studio?
Yes. Select the Visual Studio versions the add-in should be integrated in during its installation process