Veeam_VE_CheckServiceAvailability_Install.sql (Resource)

Element properties:

Source Code:

<Resource ID="Veeam_VE_CheckServiceAvailability_Install.sql" Accessibility="Internal" FileName="Veeam_VE_CheckServiceAvailability_Install.sql" HasNullStream="false"/>

File Content: Veeam_VE_CheckServiceAvailability_Install.sql

IF NOT EXISTS (SELECT * FROM sys.objects WHERE [schema_id]=SCHEMA_ID('sdk') AND type = 'P' AND name = 'Veeam_VE_CheckServiceAvailability')


BEGIN


	EXECUTE ('CREATE PROCEDURE sdk.[Veeam_VE_CheckServiceAvailability] AS RETURN 1')


END


GO





ALTER PROCEDURE [sdk].[Veeam_VE_CheckServiceAvailability]


	@mg UNIQUEIDENTIFIER


AS


BEGIN


	EXEC dbo.[Veeam_CheckServiceAvailability]


		@mg,


		'WD'


END


GO





GRANT EXECUTE ON [sdk].[Veeam_VE_CheckServiceAvailability] TO OpsMgrReader


GO