SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Security, Triggers Rss

   Items 1 to 5 of 5   

SQL Triggers in a Security Context

This article will show you how to use user-defined triggers to supplement your security policies, preventing unauthorised data manipulation and blocking unfriendly logins.  Read more...
By Derek Colley 2012/07/12 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,920 reads

Login Failed

By Marcin Zawadzki 2009/07/14 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 3,708 reads

Connecting to SQL Server with a Bad Logon Trigger

One of the things you need to aware of is that if you create a logon trigger and there is some bad code you are going to prevent everyone from logging into your SQL Server, even if you try as "sa" or a member of the sysadmin fixed server role. How do I log on to my SQL Server to fix this trigger?  Read more...
By Additional Articles 2008/12/02 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 3,757 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,208 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 6,399 reads
   Items 1 to 5 of 5   
administration (2)    
backup and restore (2)    
configuring (2)    
dts (2)    
indexing (2)    
installation (2)    
miscellaneous (2)    
sql server 7 (2)    
stored procedures (2)    
t-sql (2)    
user defined function (udf) (2)    
distributed queries (1)    
english query (1)    
logon triggers (1)    
monitoring (1)    
openxml (1)    
performance tuning (1)    
replication (1)    
sql server (1)    
updategrams (1)    
xml (1)    
xsl (1)