Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Script pattern of Store procedures.

Author  Topic 

feejaz
Yak Posting Veteran

68 Posts

Posted - 2008-08-28 : 05:32:34
Hi all,
I want to creates scripts of store procedures using like
If Exists (---- procedure name----)
DROP PROCEDURE [dbo].[procedure name]
Go
Create Procedure procedure name
(
Procedure body
)
how can I perform like that in the SqlExpress 2005

thanks,

feejaz

Navi

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-08-28 : 05:57:01
isn't there a script database feature in express? you can choose only to script sprocs there.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-08-28 : 07:12:01
or
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/13/script-out-procedures-and-functions-part-2.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -