Post reply

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

  • April 2, 2008 at 11:59 pm

    #124630

    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

  • April 3, 2008 at 12:35 am

    #797623

    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

  • April 3, 2008 at 1:00 am

    #797638

    Thanks very much!

  • October 10, 2012 at 12:12 am

    #1547464

    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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply