Семь раз ALTER один DROP

if object_id(N'SmthProc', N'p') is not null
	set noexec on;
go

create procedure SmthProc
as
	set nocount on;
go

set noexec off;
go

alter procedure SmthProc
as
begin
	set nocount on

	print N'SmthProc'
end
go

а так?