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 2005 Forums
 Transact-SQL (2005)
 Need help in script generation

Author  Topic 

mahender
Starting Member

12 Posts

Posted - 2011-12-12 : 03:09:27
hi ,
i have filtered a list of modified procedures , views, function and triggers with date.

Since the count is big, i need a query to generate a one file script with all the sp, fun , trigg, vw scripts in it.

If u have any idea or query, kindly help out asap.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-12-12 : 05:47:02
Try this
http://beyondrelational.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 -