I.1 Procedure for deleting A4QHITACHIPROCSPDATABASES
You can delete the A4QHITACHIPROCSPDATABASES stored procedure by using the sp_drop.sql script provided by PFM - Agent for Microsoft SQL Server.
To delete A4QHITACHIPROCSPDATABASES:
-
Set up an environment in which the sqlcmd utility of Microsoft SQL Server can be executed.
The sqlcmd utility is provided by Microsoft. For details about the environment settings for Microsoft SQL Server, see your Microsoft SQL Server documentation.
-
Move to the folder in which the sp_drop.sql script is located.
The script is located in the following folder:
installation-folder\agtq\agent\sql
-
Execute the script with the monitored Microsoft SQL Server instance specified.
The command line for executing the sp_drop.sql script depends on the type of the monitored Microsoft SQL Server instance and the method of authentication used for connecting to Microsoft SQL Server. The following shows the command line for each condition.
-
When the default instance of Microsoft SQL Server is being monitored
Authentication
Command line for executing the sp_drop.sql script
SQL Server
sqlcmd -S host-name -U user-name -P password -d master -i sp_drop.sql #
Windows
sqlcmd -S host-name -E -d master -i sp_drop.sql #
-
When a named instance of Microsoft SQL Server is being monitored
Authentication
Command line for executing the sp_drop.sql script
SQL Server
sqlcmd -S host-name\instance-name -U user-name -P password -d master -i sp_drop.sql #
Windows
sqlcmd -S host-name\instance-name -E -d master -i sp_drop.sql #
- #
-
The following describes the items that the user specifies:
host-name: Name of the host on which the monitored Microsoft SQL Server instance operates
instance-name: Name of the monitored Microsoft SQL Server instance
user-name: sa or a user account having the permissions equivalent to sa (account of a member of the sysadmin fixed server role)
password: Password for the specified user name
-