Query to get DROP AND CREATE an SP

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

SQL Server 2008 Forums

Transact-SQL (2008)

Query to get DROP AND CREATE an SP

Author

Topic

baburk
Posting Yak Master

108 Posts

Posted - 2009-11-13 : 04:10:08

Hi,

I am in-need of query which produce DROP AND CREATE of Stored Procedures.?

Thanks,
Babu Kumarasamy.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-11-13 : 05:15:17

quote:
Originally posted by baburk

Hi,

I am in-need of query which produce DROP AND CREATE of Stored Procedures.?

Thanks,
Babu Kumarasamy.

What is wrong with Generate SQL Script feature from SSMS?

Madhivanan

Failing to plan is Planning to fail

baburk
Posting Yak Master

108 Posts

Posted - 2009-11-13 : 21:52:00

quote:
Originally posted by madhivanan

quote:
Originally posted by baburk

Hi,

I am in-need of query which produce DROP AND CREATE of Stored Procedures.?

Thanks,
Babu Kumarasamy.

What is wrong with Generate SQL Script feature from SSMS?

Madhivanan

Failing to plan is Planning to fail

I have to get it in my vb.net application for our maintenance.

Thanks for your reply.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-11-16 : 01:36:57

Refer this
http://sqlblogcasts.com/blogs/madhivanan/archive/2009/10/26/script-out-procedures-to-seperate-files.aspx

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources