Unix Technical Forum

Can you tell who last edited a SProc, and when?

This is a discussion on Can you tell who last edited a SProc, and when? within the SQL Server forums, part of the Microsoft SQL Server category; --> I know SQL Server has a bunch of system tables that have interesting little tidbits of info in them, ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-29-2008, 09:26 PM
Hermes
 
Posts: n/a
Default Can you tell who last edited a SProc, and when?

I know SQL Server has a bunch of system tables that have interesting
little tidbits of info in them, is there any way to tell who last
edited a stored procedure or view, and when they did it? Using the
Summary page all you get is the creation date. Any help is
appreciated.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 05-13-2008, 07:13 PM
eisaacs@gmail.com
 
Posts: n/a
Default Re: Can you tell who last edited a SProc, and when?

I'm not aware of any system tables that track who last created/altered
a sproc. Your best bet is to track the sprocs as script files that
you check into and out of a source control application such as MS
SourceSafe, MS Team Systems, or a third-party tool, such as SourceGear
Vault. If you track the creation scripts in one of those, you'll know
who made the last changes and what exactly was changed and when. By
far the best of the bunch is Team Systems, but it's pretty pricey if
you have a large team of developers. We use SourceGear Vault since
it's more reliable than the file base SourceSafe and a lot less
expensive than Team System. Using these tools doesn't exactly prevent
others from changing the objects in the db directly, but it will
usually cause there changes to be overwritten later when someone
checks it out properly and updates the object correctly. In other
words, it doesn't prevent fraud or the like, but it will help keep
track of who made legitimate changes and when.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:50 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com