grab our rss feed

stevienova.com

Homepage of Steve Novoselac

Entries Tagged ‘SQL 2005’

SQL Server 2005 - DDL Triggers - Setting Up Auditing

New with SQL Server 2005, is the ability to set up triggers on DDL statements. This has got to be a DBA’s dream come true. You can set up audit logs on creates/alters, etc. Here is how you do it (this is just a trigger, you will need to create the table, you should be [...]

Leave a Comment | 196 views

VS.NET 2005 and SQL 2005 and Webhosting

Well, I finally installed SQL Server 2005 Beta 2 and VS.NET Beta 1 on a VMWare Image. Maybe I can start to play with it a little bit and check out the cool new features I have read about and seen in demos. Nothing like geekin out to get over post election blues? I also [...]

Leave a Comment | 90 views

MSDN Event : SQL Server “Yukon” 2005

The next version of SQL Server is going to be released in 2005. We saw a preview of the IDE and some features that will be available.
One major point is that the IDE is integrated into one program (SQL Workbench) instead of two in SQL Server 2000 (Query Analyzer and Enterprise Manager). The new IDE [...]

Leave a Comment | 264 views