erro ao criar função de particionamento

[EMSO.EXE]

Ao criar uma função de particionamento o Microsoft SQL Server Management Studio (2008 R2) acusa que o objeto já existe no banco.

Mensagem de erro: There is already an object named 'PF_HISTORICOVENDA' in the database

-- SELECIONAR BANCO DE DADOS
USE [dbXPTO]
GO

-- CRIAR FILEGROUPS
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1985
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1986
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1987
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1988
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1989
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1990
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1991
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1992
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1993
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1994
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1995
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1996
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1997
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1998
ALTER DATABASE dbXPTO ADD FILEGROUP FGP1999
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2000
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2001
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2002
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2003
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2004
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2005
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2006
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2007
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2008
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2009
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2010
ALTER DATABASE dbXPTO ADD FILEGROUP FGP2011

-- CRIAR ARQUIVOS DE DADOS RELACIONANDO AOS GRUPOS
USE [master]
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1985', 
FILENAME = 'C:\db\F1985.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1985
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1986', 
FILENAME = 'C:\db\F1986.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1986
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1987', 
FILENAME = 'C:\db\F1987.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1987
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1988', 
FILENAME = 'C:\db\F1988.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1988
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1989', 
FILENAME = 'C:\db\F1989.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1989
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1990', 
FILENAME = 'C:\db\F1990.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1990
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1991', 
FILENAME = 'C:\db\F1991.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1991
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1992', 
FILENAME = 'C:\db\F1992.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1992
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1993', 
FILENAME = 'C:\db\F1993.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1993
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1994', 
FILENAME = 'C:\db\F1994.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1994
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1995', 
FILENAME = 'C:\db\F1995.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1995
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1996', 
FILENAME = 'C:\db\F1996.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1996
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1997', 
FILENAME = 'C:\db\F1997.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1997
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1998', 
FILENAME = 'C:\db\F1998.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1998
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F1999', 
FILENAME = 'C:\db\F1999.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP1999
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2000', 
FILENAME = 'C:\db\F2000.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2000
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2001', 
FILENAME = 'C:\db\F2001.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2001
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2002', 
FILENAME = 'C:\db\F2002.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2002
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2003', 
FILENAME = 'C:\db\F2003.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2003
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2004', 
FILENAME = 'C:\db\F2004.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2004
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2005', 
FILENAME = 'C:\db\F2005.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2005
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2006', 
FILENAME = 'C:\db\F2006.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2006
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2007', 
FILENAME = 'C:\db\F2007.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2007
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2008', 
FILENAME = 'C:\db\F2008.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2008
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2009', 
FILENAME = 'C:\db\F2009.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2009
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2010', 
FILENAME = 'C:\db\F2010.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2010
GO

ALTER DATABASE dbXPTO ADD FILE ( NAME = 'F2011', 
FILENAME = 'C:\db\F2011.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB ) 
TO FILEGROUP FGP2011
GO

-- CRIACAO DA FUNCAO DE PARTICIONAMENTO ---------------------------------- AQUI OCORRE O ERRO ------------------------------
CREATE PARTITION FUNCTION PF_HISTORICOVENDA (DATETIME) AS
RANGE LEFT FOR VALUES (
'1985-01-01','1986-01-01','1987-01-01','1988-01-01','1989-01-01',
'1990-01-01','1991-01-01','1992-01-01','1993-01-01','1994-01-01',
'1995-01-01','1996-01-01','1997-01-01','1998-01-01','1999-01-01',
'2000-01-01','2001-01-01','2002-01-01','2003-01-01','2004-01-01',
'2005-01-01','2006-01-01','2007-01-01','2008-01-01','2009-01-01',
'2010-01-01','2011-01-01'
)
------------------------------------------------------------------------------------------- AQUI OCORRE O ERRO ------------------------------

CREATE PARTITION SCHEME SCHEMA_VENDA AS
PARTITION PF_HISTORICOVENDA TO (FGP1985,FGP1986,FGP1987,FGP1988,FGP1989,FGP1990,
FGP1991,FGP1992,FGP1993,FGP1994,FGP1995,FGP1996,FGP1997,FGP1998,FGP1999,FGP2000,
FGP2001,FGP2002,FGP2003,FGP2004,FGP2005,FGP2006,FGP2007,FGP2008,FGP2009,FGP2010,
FGP2011)

-- EXCLUINDO INDICE CLUSTERED
ALTER TABLE VENDA DROP CONSTRAINT PK_VENDA

-- CRIANDO INDICE CLUSTERED
ALTER TABLE VENDA
ADD CONSTRAINT PK_VENDA PRIMARY KEY CLUSTERED (CD_VENDA, DT_VENDA) ON SCHEMA_VENDA(DT_VENDA)

[fulvio]

Bom dia EMSO,

Pesquise na base se o objeto existe:

SELECT * FROM sysobjects s WHERE NAME = 'PF_HISTORICOVENDA'

Caso queira, poderá utilizar o IF EXISTS para identicar a sua criação ou não na base.