skip to main | skip to sidebar

Maxim Oleznyuk's BI Blog

Wednesday, January 30, 2008

SQL Server 2005 Logon Triggers

Every time a user connects to the database a trigger is fired. In the logon trigger you simple insert a row into an auditing table. Yuo can read about SQL Server 2005 Logon Triggers here.
Posted by Maxim Oleznyuk
Labels: Notes, SQL Server
Newer Post Older Post Home

Categories

  • About This Blog (1)
  • Analysis Services (7)
  • Architecture and Design (4)
  • Articles Best Practices and White Papers (10)
  • Business Intelligence (7)
  • Data Warehouse (8)
  • Documentation and Info (8)
  • Downloads (5)
  • ETL (6)
  • Literature (3)
  • News (6)
  • Notes (4)
  • Programming (5)
  • Samples (2)
  • SQL Server (12)
  • Tools (3)
  • Webcasts and Events (1)

Blog Archive

  • ►  2012 (2)
    • ►  July (1)
    • ►  June (1)
  • ►  2011 (5)
    • ►  November (1)
    • ►  October (1)
    • ►  September (3)
  • ►  2010 (1)
    • ►  August (1)
  • ▼  2008 (11)
    • ►  December (1)
    • ►  March (1)
    • ▼  January (9)
      • SQL Server 2005 Logon Triggers
      • What's New (SQL Server 2008)
      • MERGE Statement in MS SQL Server 2008
      • SQL Server 2005: CLR Integration Team Blog
      • Lutz Roeder's Programming.NET Site
      • Regular Expressions Resources
      • Improving Performance with SQL Server 2005 Indexed...
      • Implementing Row- and Cell-Level Security Using SQ...
      • Some Interesting SQL Server Articles
  • ►  2007 (14)
    • ►  November (2)
    • ►  October (2)
    • ►  August (4)
    • ►  July (6)

Links

  • Chris Webb's BI Blog
  • Kimball Group
  • SQL BI by Marco Russo
  • SQLBI.eu
  • SQLIS.com
  • SSAS MSDN Forum
  • SSAS-Info.com

About Me

My photo
Maxim Oleznyuk
View my complete profile