/SqlServer2005_SP2/HelloWorld/Scripts/HelloWorld/Cleanup.sql

 1--------------------------------------------------------------------
 2-- Summary: Cleanup script for Service Broker HelloWorld sample.
 3-- 
 4--------------------------------------------------------------------
 5-- This file is part of the Microsoft SQL Server Code Samples.
 6-- Copyright (C) Microsoft Corporation. All Rights reserved.
 7-- This source code is intended only as a supplement to Microsoft
 8-- Development Tools and/or on-line documentation. See these other
 9-- materials for detailed information regarding Microsoft code samples.
10--
11-- THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF
12-- ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO
13-- THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A
14-- PARTICULAR PURPOSE.
15--------------------------------------------------------------------
16-- Drop InitiatorService if the service exists.
17
18IF EXISTS (SELECT *
19           FROM sys.services
20           WHERE name = 'InitiatorService')
21BEGIN
22    DROP SERVICE InitiatorService ;
23END ;
24GO
25
26-- Drop TargetService if the service exists.
27
28IF EXISTS (SELECT *
29           FROM sys.services
30           WHERE name = 'TargetService')
31BEGIN
32    DROP SERVICE TargetService ;
33END ;
34GO
35
36-- Because contracts depend on message types, the script
37-- drops contracts before dropping message types.
38
39-- Drop HelloWorldContract if the contract exists.
40
41IF EXISTS (SELECT *
42           FROM sys.service_contracts
43           WHERE name = 'HelloWorldContract')
44BEGIN
45    DROP CONTRACT HelloWorldContract ;
46END ;
47GO
48
49-- Drop HelloWorldMessage if the message type exists.
50
51IF EXISTS (SELECT *
52           FROM sys.service_message_types
53           WHERE name = 'HelloWorldMessage')
54BEGIN
55    DROP MESSAGE TYPE HelloWorldMessage ;
56END ;
57GO
58
59
60-- Drop InitiatorQueue if the queue exists.
61
62IF OBJECT_ID('[dbo].[InitiatorQueue]') IS NOT NULL AND
63   EXISTS(SELECT *
64          FROM sys.objects
65          WHERE object_id = OBJECT_ID('[dbo].[InitiatorQueue]')
66            AND type = 'SQ')
67BEGIN
68    DROP QUEUE [dbo].[InitiatorQueue] ;
69END ;
70GO
71
72-- Drop TargetQueue if the queue exists.
73
74IF OBJECT_ID('[dbo].[TargetQueue]') IS NOT NULL AND
75   EXISTS(SELECT *
76          FROM sys.objects
77          WHERE object_id = OBJECT_ID('[dbo].[TargetQueue]')
78            AND type = 'SQ')
79BEGIN
80    DROP QUEUE [dbo].[TargetQueue] ;
81END ;
82GO
83--------------------------------------------------------------------