Cannot Create SP ( Error 2714 )

Hi, Trying to create a SP. But getting an error msg. Any ideas how to fix it? My SP gets the size of the tables in every DB.

Server: Msg 2714, Level 16, State 5, Procedure isp_allTableSize, Line 8
There is already an object named 'isp_allTableSize' in the database.
Server: Msg 208, Level 16, State 1, Line 18
Invalid object name 'master..TablesTemp'.
Server: Msg 208, Level 16, State 1, Line 63
Invalid object name 'master..TablesTemp'.
----------------------------------------------------------------------





-- TRUNCATE table TablesTemp

-- drop proc dbo.isp_allTableSize
CREATE PROC dbo.isp_allTableSize as
SET NOCOUNT ON



CREATE TABLE master.[dbo].[TablesTemp] (
[DatabaseName] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Rows] [char] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Reserved] [varchar] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Data] [varchar] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[IndexSize] [varchar] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Unused] [varchar] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

/*
-- SELECT COUNT (*) from master..DatabaseTables
DECLARE @date DATETIME
SELECT @date = DATEDIFF(mi, currentdate, GETDATE())
FROM master..databaseTables
IF (@date > 7)
BEGIN
TRUNCATE TABLE master..databaseTables
END
*/

DELETE master..databaseTables
WHERE DATEDIFF(DAY, currentdate, GETDATE()) > 7



DECLARE @db VARCHAR(60)
DECLARE @sql VARCHAR(8000)

DECLARE icr_getDatabases CURSOR FOR

SELECT top 1 name FROM master..sysdatabases where name <> 'tempdb'

OPEN icr_getDatabases
FETCH icr_getDatabases INTO @db
WHILE @@fetch_status = 0
BEGIN
SET @sql = 'USE [' + @db + ']

DECLARE @table_name VARCHAR(60)
DECLARE @cursor VARCHAR(8000)

DECLARE icr_getTables cursor for

SELECT table_name from information_schema.tables
WHERE table_type = ''base table''
AND table_schema = ''dbo''
AND table_name NOT LIKE ''dbo.%''

OPEN icr_getTables
FETCH NEXT FROM icr_getTables into @table_name
WHILE @@fetch_status = 0

BEGIN
INSERT master..TablesTemp
EXEC sp_spaceused @table_name

FETCH NEXT FROM icr_getTables INTO @table_name
END

CLOSE icr_getTables
DEALLOCATE icr_getTables'

EXEC (@sql)
FETCH NEXT FROM icr_getDatabases INTO @db
END
CLOSE icr_getDatabases
DEALLOCATE icr_getDatabases



INSERT master..DatabaseTables
SELECT *, GETDATE() FROM master..TablesTemp


-- TRUNCATE table DatabaseTables
-- SELECT * from master..DatabaseTables
DROP TABLE master..TablesTemp





=============================
http://www.sqlserverstudy.com