Connector Improvement: HVR SQL Server Scripts
We ran into an issue where we were deploying HVA onto the same server for different databases. As a results, when we ran the script hvrcapsysadmin.sql we had stored procedures dropped and recreated, causing previous grants to be removed. Specifically from these lines:
IF EXISTS (SELECT * FROM sys.procedures WHERE object_id = OBJECT_ID(N'sp_hvr_dblog'))
EXEC sp_executesql N'DROP PROCEDURE sp_hvr_dblog'
GOIF EXISTS (SELECT * FROM sys.procedures WHERE object_id = OBJECT_ID(N'sp_hvr_dbtable'))
EXEC sp_executesql N'DROP PROCEDURE sp_hvr_dbtable'
GO
IF EXISTS (SELECT * FROM sys.procedures WHERE object_id = OBJECT_ID(N'sp_hvr_loginfo'))
EXEC sp_executesql N'DROP PROCEDURE sp_hvr_loginfo'
GO
Since this executes agains MSDB we would like to suggest these drops be removed or also include a check to see if there are any existing grants to them to prevent them from being dropped.
-
Just to clarify, even though the title has "HVR SQL Server Scripts", this request is for SQL Server HVA connector.
Please sign in to leave a comment.
Comments
1 comment