/*=====================================================================

  File:      cleanup.sql for Manufacturing Instructions XML Example
  Summary:   Removes the stored procedure and http endpoint used in the 
			 XML manufacturing instructions sample.
  Date:	     February 11, 2004

---------------------------------------------------------------------

  This file is part of the Microsoft SQL Server Code Samples.
  Copyright (C) Microsoft Corporation.  All rights reserved.

 This source code is intended only as a supplement to Microsoft
Development Tools and/or on-line documentation.  See these other
materials for detailed information regarding Microsoft code samples.

THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY
KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A
PARTICULAR PURPOSE.

======================================================= */

use AdventureWorks
GO

IF EXISTS (SELECT * FROM sys.procedures WHERE name = 'GetManuInstructions')
  DROP PROCEDURE GetManuInstructions;
GO

USE master
GO

IF EXISTS (SELECT * FROM sys.http_endpoints WHERE name = 'sql_AdvWorksEndPointManuInstructions')
    DROP ENDPOINT sql_AdvWorksEndPointManuInstructions -- case sensitive;
GO