Merge pull request #75 from SpotOnDBA/patch-4

OpenQueryStore · web-flow · commit d84126bd042e · 2018-08-16T21:18:37.000+02:00
Update install_service_broker.sql
diff --git a/setup/install_service_broker.sql b/setup/install_service_broker.sql
@@ -157,9 +157,13 @@ SET ANSI_NULLS ON;
 GO
 
 SET QUOTED_IDENTIFIER ON;
-GO
+GO		    		    
 
-CREATE PROCEDURE [dbo].[open_query_store_startup]
+IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'open_query_store_startup')
+    EXEC ('CREATE PROC dbo.open_query_store_startup AS SELECT ''stub version, to be replaced''')
+GO
+		    
+ALTER PROCEDURE [dbo].[open_query_store_startup]
 AS
     -- This stored procedure is used to activate Open Query Store data collection using Service Broker
     -- The procedure is called at every SQL Server startup
@@ -172,4 +176,4 @@ GO
 EXEC [sys].[sp_procoption] @ProcName = 'dbo.open_query_store_startup',
                            @OptionName = 'startup',
                            @OptionValue = 'on'
-GO
+GO
