Backup stored procedures,views,user defined functions from a db

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » Backup stored procedures,views,user defined...

Backup stored procedures,views,user defined functions from a db

Rate Topic

Display Mode

Topic Options

Author

Message

dtx

Posted Wednesday, April 02, 2008 11:59 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 03, 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

SQLZ

Posted Thursday, April 03, 2008 12:35 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 02, 2013 5:38 AM
Points: 870, Visits: 858

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

dtx

Posted Thursday, April 03, 2008 1:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 03, 2012 7:51 AM
Points: 2, Visits: 42

Thanks very much!

Post #479002

Aadhar Joshi

Posted Wednesday, October 10, 2012 12:12 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:44 PM
Points: 1,045, Visits: 229

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 »

Permissions