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.
|
