<div>
If you find something like that, let me know!!!<br />
What i use to version scripts, is that I generate scripts manually (using the Scripting Wizard), even if I could use SQL-DMO...<br />
<br />
Thinking about this, you could add a trigger to master database tables: syscolumns, sysobjects, sysindexes ...<br />
Sounds like a challenge ...<br />
<br />

</div>


If you find something like that, let me know!!!
What i use to version scripts, is that I generate scripts manually (using the Scripting Wizard), even if I could use SQL-DMO...

Thinking about this, you could add a trigger to master database tables: syscolumns, sysobjects, sysindexes ...
Sounds like a challenge ...



<div>
Forgot to mention, i'm on 6.5
</div>


<div>
Installed a trial version of 7.0 . &nbsp;Don't understand quite i'm seeing just yet, but that looks what i could use IF i had 7.0.
</div>


Installed a trial version of 7.0 .  Don't understand quite i'm seeing just yet, but that looks what i could use IF i had 7.0.

<div>
<div class="content wysiwyg-content">
I'd like the t-sql that would make a trigger which would,whenever a change in permissions or indexes was made to a table or view, it would populate a table(logtable) with getdate(), the id making the change , generate sql script of the original and the new in directory called original and new. <br />
If the points seem stingy, that can be negotiated.
</div>
</div>


I'd like the t-sql that would make a trigger which would,whenever a change in permissions or indexes was made to a table or view, it would populate a table(logtable) with getdate(), the id making the change , generate sql script of the original and the new in directory called original and new. 
If the points seem stingy, that can be negotiated.

Trigger T-SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.