Trigger Happy

This article looks at using triggers to audit and to prevent the performing of unintended actions.

Filetable Insert Triggers

The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)

Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...

Add user with DDL Trigger

DDL trigger will add a user to a newly created database and assign db_owner role. It can be modified for what role is required.

Enable/Disable a table to be read only on the fly

Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?

Update Trigger to Store Only Updated Column and Former Value

History table needs individual rows for each column that has been updated, i.e., a column history.

Constraint Event Order

RE: List of Identity Columns in Database

select  * from syscolumns where autoval is not nullwill list the columns, but you need to know what you are doing if you want to add tablenames, etc

RE: DTS Question

I would use a combination.  Run the execute task to run your pre-queries.  Use the data driven task to run the query that outputs to the file.  The data driven task is well documented elsewhere.  You should have no trouble finding out how to do this.

RE: Changing SA password breaks DTS packages

I did restart the physical machines after the password has changed. I also looked thru all the connections within DTS packages and did not find any reference to SA. I ended up spending all day re-saving the packages and rescheduling them. I have to change the passwords again in 45 days and it will be […]