I am trying to run a startup script in Aqua Data Studio when a user logs in to any database. I understand that the process for this is to go to Script in the Server Registration box and write the SQL scripts/queries you would want to run when connected. I tried to retrieve the count of a small table (2 rows), but I cannot see the results anywhere when I connect to it and open a new Query Analyzer window. Is there a specific place where I can view these results that is not immediately apparent? Please help.
Aqua Data Studio Server Registration Scripts
848 Views Asked by CodingInCircles At
1
There are 1 best solutions below
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in SQL-SCRIPTS
- Exporting the data from DB by passing the data from input csv file and saving the results in csv file
- How can I run SQL scripts which are there in Azure synapse analytics workspace using azure DevOps?
- Having problems with txn_date Between over a 24hour period broken up into two 12 hour chunks
- Update column in table using snowflake scripting SQL
- How do you export Attached Documents from Database taken from Microsoft Dynamics CRM 2016?
- postgres bytea sql with parameter error on inserting and/or updating with one sql script c# .net
- Get the records from SQL table which matches on the same date
- Postgres/psql sql script: how to pass arguments as partial name
- How to extract all the table names from a Python script
- Snowflake dynamic SQL: Storing query results as variables between executions
- Sql sort script based on one column that has odd or even value
- Create mdb table from C# and using OLE OBJECT field
- How do I convert an SQL script into actual viewable data sets to include in my portfolio?
- Oracle SQL script - Package created with compilation errors
- Oracle sql script with parameters - difference between # and $
Related Questions in AQUAFOLD
- How to export registered servers passwords in Aqua Data Studio?
- Aqua Data Studio alternative
- Convert ER-Win model to Aqua Data Studio
- How export registered servers settings in Aqua Data Studio?
- How to execute SQL queries from text files
- Can Aqua Data Studio automatically connect to a database on startup?
- Aqua Data Studio Server Registration Scripts
- Aqua Data Studio Macro possible?
- Aqua Data studio, compare results, column names case-sensitive
- How to open Query Analyser (window) in Aqua Data
- Viewing query results with a parameters in Oracle
- Sybase SQL stored procedure consumes too much memory
- TOAD vs AquaFold - Connecting to Oracle
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The Scripts tab in the Server Properties, is more suited for SQL to change the Database or Schema. For e.g. For MSSQL Server, if your default database in the Server Connection is MASTER and you want to change to a database named NORTHWIND, you would need to enter USE NORTHWIND in the Scripts tab. It is not suited to run queries and view the results. This is useful if you want to perform some initialization. One thing you can look for is the FluidShell. See link here.
In server properties, next to the "Script" tab, there is a tab called "FluidShell". If you enter your startup script there and then launch FluidShell (by right clicking on your registered server > FluidShell), you'll see the script being executed and its output displayed.