Expert Guide: Mastering SQL Query Techniques

Table of Contents

• Introduction
• Registration
• Using Advanced Installer
  • GUI
  • Working with Projects
  • Installer Project
    * Product Information
    * Resources
    * Package Definition
    * Requirements
    * User Interface
    * System Changes
    * Server
    * Internet Information Services Page”)
    * ODBC
    * SQL Databases
    * Database server
    * SSRS Deployments
    * SQL Operations
    * SQL Database Browse
    * SQL Server Browse
    * SQL Test Connection
    * SharePoint Page
    * Silverlight Page
    * Custom Behavior
  • Patch Project
  • Merge Module Project
  • Updates Configuration Project
  • Windows Store App Project
  • Modification Package Project
  • Optional Package Project
  • Windows Mobile CAB Projects
  • Visual Studio Extension Project
  • Software Installer Wizards - Advanced Installer
  • Visual Studio integration
  • Alternative to AdminStudio/Wise
  • Replace Wise
  • Migrating from Visual Studio Installer
  • Keyboard Shortcuts
  • Shell Integration
  • Command Line
  • Advanced Installer PowerShell Automation Interfaces
• Features and Functionality
• Tutorials
• Samples
• How-tos
• FAQs
• Windows Installer
• Deployment Technologies
• IT Pro
• MSIX
• Video Tutorials
• Advanced Installer Blog
• Table of Contents

Disclaimer: This post includes affiliate links

If you click on a link and make a purchase, I may receive a commission at no extra cost to you.

SQL Operations

SQL Browse feature retrieves a list of PCs on the local network which are running MS SQL Server and gets information about instances or databases.

SQL Test feature tests if the SQL connection works.

Follow the video tutorial to see a basic working sample:

Creating a new Browse SQL Servers operation

To create a new SQL Server Browse operation use the[Browse SQL Servers ] toolbar button or the “New SQL Operation > Browse SQL Servers” context menu item.

Creating a new Browse SQL Databases operation

To create a new SQL Database Browse operation use the[Browse SQL Databases ] toolbar button or the “New SQL Operation > Browse SQL Databases” context menu item.

Renaming an SQL Browse operation

Use the “Rename” context menu item or press theF2 key while a browse operation is selected.

Removing an SQL Browse operation

Use the [Delete ] toolbar button, the “Delete” context menu item or press theDelete key while a browse operation is selected.

Testing SQL connections

To test an SQL connection use the [Test SQL Connection ] toolbar button or the “New SQL Operation > Test SQL Connections” context menu item.

Topics

• SQL Database Browse
  Browsing for SQL databases from a specific server.
• SQL Server Browse
  Browsing for SQL servers from the network, domain or local computer.
• SQL Test Connection
  Testing SQL Connections.

Did you find this page useful?

Please give it a rating:

Thanks!

Report a problem on this page

Information is incorrect or missing

Information is unclear or confusing

Something else

Can you tell us what’s wrong?

Send message

Also read: