Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag DDL Triggers Rss

Search for any content tagged ddl triggers

   Items 1 to 11 of 11   
 

Blocking Users by IP

SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.  Read more...
By Brian Kelley 2013/11/08 (first published: 2009/03/09) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 32,922 reads

Extend SQL Server DDL Triggers for more functionality: Part 2

A previous tip, SQL Server DDL Triggers to Track All Database Changes, generated a lot of discussion involving ways to make the provided DDL trigger more useful. Check out this tip to expand your knowledge on DDL Triggers.  Read more...
By Additional Articles 2013/06/10 | Source: MSSQLTips.com | Category: ddl triggers
Rating: (not yet rated)  Rate this |   Briefcase | 2,642 reads

Extending SQL Server DDL Triggers for More Functionality

In this tip Aaron Bertrand describes some of the ways in which you can extend the DDL trigger functionality.  Read more...
By Additional Articles 2013/05/30 | Source: MSSQLTips.com | Category: ddl triggers
Rating: (not yet rated)  Rate this |   Briefcase | 3,783 reads

Blocking Users by IP

SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.  Read more...
By Brian Kelley 2013/11/08 (first published: 2009/03/09) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 32,922 reads

SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution

DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.  Read more...
By Sean Elliott 2010/08/17 | Source: SQLServerCentral.com | Category: ddl
Rating: |  Discuss |   Briefcase | 7,204 reads

Granting limited permissions to create views in another schema in SQL Server - Part 2

In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.  Read more...
By Additional Articles 2009/08/17 | Source: MSSQLTips.com | Category: schema
Rating: (not yet rated)  Rate this |   Briefcase | 2,753 reads

Creating a recycle bin for SQL Server 2005\2008

Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.   Read more...
By Chris Goldsmith 2009/05/20 | Source: SQLServerCentral.com | Category: ddl triggers
Rating: |  Discuss |   Briefcase | 11,744 reads

Blocking Users by IP

SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.  Read more...
By Brian Kelley 2013/11/08 (first published: 2009/03/09) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 32,922 reads

Securing SQL with access control and login monitoring

SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.  Read more...
By Additional Articles 2009/02/16 | Source: SearchSQLServer | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,590 reads

Monitoring Changes in Your Database Using DDL Triggers

Auditing and monitoring activity in your databases is becoming more and more important all the time. New author David Dye brings us a short introduction to using DDL triggers to help.  Read more...
By David Dye 2008/10/02 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 8,768 reads

Using DDL triggers to audit events

Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.  Read more...
By Additional Articles 2008/05/15 | Source: SearchSQLServer | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 2,779 reads
   Items 1 to 11 of 11