MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

ESSENTIALS: Home | Tips | Search | Categories | Top 10 | Products | Authors | Blogs | Forums | Webcasts | Advertise | About

Today's Tip

Using the EventData() Function with DDL triggers in SQL Server 2005
 

Additional Tips

Built-In Performance Reports in SQL Server 2005
COPY_ONLY Backups with SQL Server 2005
How To Build a Cube From an Existing Data Source Using SQL Server Analysis Services
 

Latest Webinars

SQL Server Fragmentation - Fact vs. Fiction
SQL Server 2008 Performance Improvements
Getting Started with SSIS - Part1
 

Active Forum Posts

Dynamically build connection objects for Microsoft Access databases in SQL Server Integration Services
Managing SQL Server Database and Application Metadata
please help
Running a Dynamic Query against SQL Server without using Dynamic SQL
Write query by using excel's parameters with parameter of cells of it
 

Unanswered
Forum Posts

[Microsoft][SQL Native Client]TCP Provider: Timeout error [258]
comparison between crystel reports and sql server reporting services
Message from TechNet Flash: SQL Server 2008 released!
Microsoft's "SQL Server Playback" Program
Report Server Virtual Directories Question
 

Blog Posts

Installation and Configuration Outline
How to determine service-related priviledges for Sql Server service account
Fragmentation Station - Stop #2 - What it is, what types there are
 

Advertise

To learn about advertising click here
 

Authors

To learn about writing tips click here
Today's Sponsor
 
Today's Tip   
Using the EventData() Function with DDL triggers in SQL Server 2005

In the Auditing DDL (Create, Alter, Drop) Commands in SQL Server 2005 tip, you have seen how you can track DDL activities in your server instance. But how do we store the events captured by these DDL triggers and store it in a table for reporting purposes?
 
Most Recent Tips Most Popular Tips Most Read Tips

Using the EventData() Function with DDL triggers in SQL Server 2005

Running a Dynamic Query against SQL Server without using Dynamic SQL

Vacation for a SQL Server DBA

SQL Server DBA Telecommuting Tips

Windows Integrated Authentication Failures to SQL Server

SQL Server Security Interview Questions

Managing SQL Server Database and Application Metadata

Database Mirroring Automating Failover for Multiple Databases

How To Implement Proactive Caching in SQL Server Analysis Services (SSAS) 2005

more tips...

Recover from a SQL Injection Attack on SQL Server

Calculating Mathematical Values in SQL Server

T-SQL Function to Determine Holidays in SQL Server

The Many Uses of Coalesce in SQL Server

Using SQL Servers OPENROWSET to break the rules

Create a SQL Server Data Dictionary in Seconds using Extended Properties

Dynamically controlling the number of rows affected by a SQL Server query

Rebuilding the SQL Server master database - Part 1

Inserting, Updating or Deleting Data in SQL Server from an Excel Spreadsheet

Reading the SQL Server log files using T-SQL

Export data from SQL Server to Excel

Date/Time Conversions Using SQL Server

SQL Server 2000 Text Data Manipulation

Different Options for Importing Data into SQL Server

Error - Windows cannot access the specified device, path or file.

Grant Execute to all SQL Server Stored Procedures

Deleting Data in SQL Server with TRUNCATE vs DELETE commands

Enabling xp_cmdshell in SQL Server 2005

SQL Server T-SQL Aggregate Functions

Deploying a SQL Server 2000 DTS Package vs. a SQL Server 2005 Integration Services Package (SSIS)
 
Information From Our Sponsors
Try Idera’s new SQL admin toolset: 24 essential tools for SQL Server Management

Download a free trial and see how Red Gate’s SQL Compare will reduce your workload (and the inevitable human errors) by up to 90%.

Trouble-free SQL Servers. No 1-size-fits-all solution. Focus on your servers and keep them healthy!

Worried about Disaster Recovery? Learn how to protect your SQL servers using SonaSafe from Sonasoft

SQL Nitro found the secret to 65 percent faster queries with network compression technology yielding a fantastic SQL Server ROI.

Industry Leading Products
   SQL Prompt
Fast, intelligent, T-SQL code-completion add-in for Visual Studio, SSMS and Query Analyzer. SQL Prompt helps you write faster, neater SQL queries without having to know the details of the database schema. Preset exactly how and when SQL Prompt responds to your needs. Free 14-day trial download. ...
Copyright (c) 2006-2008 Edgewood Solutions, LLC All rights reserved
privacy statement | disclaimer | copyright | advertise | write for us
Some names and products listed are the registered trademarks of their respective owners.