Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,825 reads

Login Failed

By Marcin Zawadzki 2009/07/14 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 3,686 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,226 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,205 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,398 reads
   Items 1 to 5 of 5   
 
Tags
administration (2)    
backup / 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)