XSW: Managing a database through console commands

XSW: Managing a database through console commands

sqlcmd -S Server/Instance -U Bob0101 -q "use [master];"Connects to that server, and then uses the master Database
Password123Enters password
SELECT * FROM sys.databases;Displays a list of all databases
GORuns the command
USE Database;Begins to use a specifc Database
GORuns the command
SELECT * FROM xylog WHERE level LIKE '%error%' AND productName LIKE '%LOADER%';Due to the nature of the window in older models, it may be smarter to restrict query.
GORuns the command
EXITExits



If you are unable to locate the solution needed or if you need additional assistance please Click Here to open a case from our Customer Care Portal.


    • Related Articles

    • XSW: "Incompatible database version" error generated during connection test

      Customer can use upgrade option on the XSW Data Management tool to upgrade the Database to the version compatible with GUI. Steps: 1. Opening the XSW Data Management GUI 2. Making sure Server Instance Name and Authentication Mode are both correct. 3. ...

    • XSW: "Incompatible Database Version" Wrong Error

      The actual problem was found in the SQL database error log, this error was " Error occurred - schema common cannot be created." The Database User, who will be creating the database should have the sysadmin role (or similar permissions to a sysadmin ...

    • XSW: How to add new XSW users to the XSW SQL server database

      To assign a new user to the xsw_role, In SQL server management studio, select: Security logins right-click on the user to be added to the xsw_role properties user mapping then select xsw_role and hit "OK" to save the change. If you are unable to ...

    • XWG: How to find out the XSW database version in SQL SERVER?

      The easiest way is to Open the SQL Server Management Studio and run the below query. In the example below, the database version is XSW 3.25. Open Microsoft SQL Server Management Studio. Click to open Databases folder Right click on the XYGATESW ...

    • XSW: load error ?Cannot open database ''.

      Upgrading to an MSSQL supported version of XSW (3.15 or higher) is required. Contact XYPRO for support for more details. If this article did not provide a solution, please open a case with our support team by sending an email message to ...