Results 1 to 4 of 4

Thread: How to track Stored procedure changes

  1. 11-19-2005, 11:04 AM #1
    kpsreenath
    kpsreenath is offline Registered User
    Join Date
    Oct 2005
    Posts
    21

    How to track Stored procedure changes

    Hi

    I have a stored procedure for which i need to track the changes.
    I wanted to know which user has updated the stored procedure and what all changes are done to it.
    I thought of getting these details from the transaction log, but looks like sql server 2000 doesnt have any log reader.

    Kindly help
    Thanks in advance
    Sreenath
    Reply With Quote Reply With Quote
  2. 11-19-2005, 02:34 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Transaction log does contain log of DDL changes, but you need a reader to see that. Log Exporer from www.lumigent.com is one such tool. But since you do not have it installed in your system, it can't tell you who modified (NT user) it, it can only tell you that it was modified by a SQL user.
    Reply With Quote Reply With Quote
  3. 11-21-2005, 12:12 AM #3
    kpsreenath
    kpsreenath is offline Registered User
    Join Date
    Oct 2005
    Posts
    21
    Thanks sKhanal
    Reply With Quote Reply With Quote
  4. 11-21-2005, 03:48 PM #4
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    http://www.databasejournal.com/featu...le.php/3401081
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules