I.1 Procedure for deleting R4QHITACHIPROCSPDATABASES
You can delete the R4QHITACHIPROCSPDATABASES stored procedure by using the sp_rdrp.sql script provided by PFM - RM for Microsoft SQL Server.
To delete R4QHITACHIPROCSPDATABASES:
-
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_rdrp.sql script is located.
The script is located in the following folder:
installation-folder\agt4\agent\sql
-
Execute the script with the monitored Microsoft SQL Server instance specified.
The command line for executing the sp_rdrp.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_rdrp.sql #
Windows
sqlcmd -S host-name -E -d master -i sp_rdrp.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_rdrp.sql #
Windows
sqlcmd -S host-name\instance-name -E -d master -i sp_rdrp.sql #
-