SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-29-2008, 08:26 PM
| ||||
| ||||
 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.      |
|
05-13-2008, 06:13 PM
| ||||
| ||||
| 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. |
Linear Mode
