Block user objects from being created in a master database

Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]

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.