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

  File:      Cleanup.sql for Online Catalog
  Summary:   Uninstalls server objects for the sample which Retrieves 
             product information from the Adventure Works databases.
  Date:	     April 29, 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 = 'GetProductDescription')
  DROP PROCEDURE GetProductDescription;
GO

USE master
GO

-- Drop old end point if it exists
IF EXISTS (SELECT * FROM sys.http_endpoints WHERE name = 'sql_ProductCatalog')
  DROP ENDPOINT sql_ProductCatalog; -- case sensitive
GO