Good Morning! Well, I have not seen any answers yet, so let me add this.
Way back in my archives, I found a reference to this. This is it: "So how do you version-control stored procedures? For a longer discussion, I refer to my article 'Edit and Safeguard Your T-SQL Code' in the January 2000 issue of the SQL Server Professional. But here's a synopsis of how we do it in our shop: We use an external editor to edit our SQL objects -- not only stored procedures, but also tables, indexes, and so on, which should also be under version control. The editor we use permits us to invoke a command-line tool such as ISQL or OSQL. We check in and out with the VSS Explorer, following the cycle 1-6 I outlined above." I do not have access to the January 2000 issue of the SQL Server Professional. Maybe you do or can get access to it. HTH...Dan'l --- Marselle Caston <[EMAIL PROTECTED]> wrote: > > Does anyone out there know how to write a trigger in > SQL Sever. > what I need is a trigger that will store in a table > the user Id of someone who went in and changed a > line > in a storedProc on the server and one that will > store > the Stored procedure code as well as what it is > when > someone has changed the code.. > I need this because someone at work is changing my > code and knowone will own up to it.. so I need a way > to track this in a trigger... is this possible...? > > MC > > > > __________________________________ > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! > http://smallbusiness.yahoo.com/resources/ > > > ----------------------------------------------------- > Home page: http://groups.yahoo.com/group/delphi-en/ > To unsubscribe: > [EMAIL PROTECTED] > Yahoo! Groups Links > > > [EMAIL PROTECTED] > > > > > > ____________________________________ Every day is a Great day, but some days are GREATER than others! __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
