Generating 'if exists....' script for stored procedures in SQL Server 2005

Question

Generating 'if exists....' script for stored procedures in SQL Server 2005

essridhar

Grasshopper

Points: 14
More actions
May 29, 2008 at 11:10 pm

#188286

Hi,
How do I make SQL Server 2005 generate the following script for my stored procedure which used to happen automatically while creating a stored procedure in SQL Server 2000 -
======================
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Proc_mySP]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Proc_mySP]
GO
======================
Also, whether at all it is a good practice to have this script in every stored procedure ?
-Sri

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

There is a option to generate scripts. Rightclick on the db\Tasks\GenerateScripts. On the "choose script options" page can say "True" to "Include IF NOT Exists."

"Keep Trying"