--EXEC sp_help ReportViewSourceParameter CREATE TABLE temp1_ReportViewSourceParameter ( SourceID INT NULL, ParameterTypeCode NVARCHAR(80) NULL, ParameterKey NVARCHAR(256) NULL, ParameterIndex INT NULL, ParameterValue NVARCHAR(256) NULL, DocumentID INT NULL, UserVisible BIT NULL, InheritChildSourceFilters BIT NULL ) GO INSERT INTO temp1_ReportViewSourceParameter SELECT SourceID, ParameterTypeCode, ParameterKey, ParameterIndex, ParameterValue, DocumentID, UserVisible, InheritChildSourceFilters FROM ReportViewSourceParameter GO EXEC sp_rename 'ReportViewSourceParameter', 'ReportViewSourceParameter_old' GO EXEC sp_rename 'temp1_ReportViewSourceParameter', 'ReportViewSourceParameter' GO