SQLServerCentral / Backups / SQL Server 7,2000 / Backup stored procedures,views,user defined functions from a db / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 06:41:25 GMT20RE: Backup stored procedures,views,user defined functions from a dbhttp://www.sqlservercentral.com/Forums/Topic478974-24-1.aspxYou can use how to check last updated stored procedures by below queries..SELECT nameFROM sys.objectsWHERE type = 'P'AND DATEDIFF(D,create_date, GETDATE()) < 7select name,create_date,modify_datefrom sys.proceduresorder by modify_date descWed, 10 Oct 2012 00:12:48 GMTAadhar JoshiRE: Backup stored procedures,views,user defined functions from a dbhttp://www.sqlservercentral.com/Forums/Topic478974-24-1.aspxThanks very much!Thu, 03 Apr 2008 01:00:49 GMTdtxRE: Backup stored procedures,views,user defined functions from a dbhttp://www.sqlservercentral.com/Forums/Topic478974-24-1.aspxYou 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.Thu, 03 Apr 2008 00:35:00 GMTSQLZBackup stored procedures,views,user defined functions from a dbhttp://www.sqlservercentral.com/Forums/Topic478974-24-1.aspxHi 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.ThanksWed, 02 Apr 2008 23:59:25 GMTdtx