duplicate.sql

/* Trying to reproduce a reported duplicate naming issue in SQL Change Automation */

CREATE TABLE dbo.duplicate (i INT IDENTITY)

CREATE TYPE duplicate AS TABLE   
( i INT );  
GO 



CREATE PROCEDURE dbo.useduplicate 
    @duplicate duplicate READONLY  
    AS   
		SELECT * FROM @duplicate;
		
		DECLARE @duplicate2 AS duplicate;  
  
INSERT INTO @duplicate2 (i)  
    SELECT 1;  
  
GO  


CREATE TRIGGER tr_duplicate ON dbo.duplicate AFTER INSERT AS 
BEGIN 
DELETE FROM dbo.duplicate WHERE 1 = 0
END 
GO