Professional Web Applications Themes

script to show last change date for stored procedures and tables? - Microsoft SQL / MS SQL Server

I need a script that will display the last change date for the definitions for stored procedures and tables within a database. I'd also be very interested in a script that would compare 2 databases - and display the differences. -- Thanks in advance, Les Caudle...

  1. #1

    Default script to show last change date for stored procedures and tables?

    I need a script that will display the last change date for the definitions for
    stored procedures and tables within a database.

    I'd also be very interested in a script that would compare 2 databases - and
    display the differences.
    --
    Thanks in advance, Les Caudle
    Les Caudle Guest

  2. #2

    Default Re: script to show last change date for stored procedures and tables?

    to compare databases and incorporate change control use DB
    Ghost from [url]www.DBGhost.com[/url] .It makes sure your source (in
    source-safe) is an accurate reflection of any environment.
    This will give you the absolute ability to version your
    database changes. Check out the site it's well worth a
    read.
    >-----Original Message-----
    >SQL Server doesn't keep information about the last change
    date for tables,
    >stored procedures etc. Use a version control system like
    Sourcesafe if you
    >want to keep track of changes.
    >
    >To compare 2 databases you can use SQLCompare from
    [url]www.red-gate.com[/url], a tool
    >well worth it's price.
    >
    >--
    >Jacco Schalkwijk MCDBA, MCSD, MCSE
    >Database Administrator
    >Eurostop Ltd.
    >
    >
    >"Les Caudle" <verytiredofspam.com> wrote in message
    >news:ggq5gvof7onm5kri833ifmim040hg579sd4ax.com.. .
    >> I need a script that will display the last change date
    for the definitions
    >for
    >> stored procedures and tables within a database.
    >>
    >> I'd also be very interested in a script that would
    compare 2 databases -
    >and
    >> display the differences.
    >> --
    >> Thanks in advance, Les Caudle
    >
    >
    >.
    >
    Mark Baekdal Guest

Similar Threads

  1. Stored Procedures with Date data types and Oracle
    By jasun123 in forum Coldfusion Database Access
    Replies: 16
    Last Post: June 8th, 07:43 PM
  2. Stored Procedures
    By Anthony M. Davis in forum Coldfusion - Advanced Techniques
    Replies: 28
    Last Post: February 9th, 03:17 PM
  3. cf 7 and mysql 5 stored procedures and temporary tables
    By gnurulz in forum Coldfusion Database Access
    Replies: 2
    Last Post: December 10th, 02:58 AM
  4. dt_ Stored Procedures
    By chopper in forum ASP Database
    Replies: 2
    Last Post: July 20th, 04:06 PM
  5. Stored Procedures and 4GL
    By Ahmer Sajjad in forum Informix
    Replies: 1
    Last Post: September 9th, 01:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139