Deploying the stored procedure

After opening the download link, you will find the stored procedure’s code displayed in a new window in your browser; copy the code in a new session in SQL Server Management Studio connected to the server that we want to deploy it at and run it as is. After the first run, the stored procedure is created in master (unless you changed it) and after that, all it is left to do is to execute it by running: EXEC [sp_health_check];


Shortly, this section will contain guidelines on how to read and address the output resulted from the stored procedure’s execution.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s