Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup stored procedures,views,user defined functions from a db Expand / Collapse
Author
Message
Posted Wednesday, April 2, 2008 11:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 3, 2012 7:51 AM
Points: 2, Visits: 42
Hi all!

Is there a way to backup/dump all stored procedures, views, user defined functions and also triggers (if possible) from a database in MSSQL 2000?

In fact I want to move all stored procedures, views, user defined functions and triggers from one database to another.
The databases have the same structure but contain different data.

Thanks
Post #478974
Posted Thursday, April 3, 2008 12:35 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 17, 2014 9:11 AM
Points: 870, Visits: 906
You can script all the database objects (including tables if you wanted to). Right-Click on the database, go to All Tasks > Generate SQL Script and follow the instructions from there.

Karl
source control for SQL Server
Post #478984
Posted Thursday, April 3, 2008 1:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 3, 2012 7:51 AM
Points: 2, Visits: 42
Thanks very much!
Post #479002
Posted Wednesday, October 10, 2012 12:12 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 5:34 AM
Points: 1,608, Visits: 378
You can use how to check last updated stored procedures by below queries..

SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 7


select name,create_date,modify_date
from sys.procedures
order by modify_date desc
Post #1370696
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse