General ravings…IDW9….

Hello again I’m pleased to announce that the latest build of SQL Server 2005 includes two new T-SQL commands, INTERSECT and EXCEPT.  I’ll talk about these a little later. I’ve just been on a great 2005 training course delivered by Niels Berglund of developmentor.  Niels has introduced me to some great features which I’ll talk about in this blog. …

1

SQL Server 2005 Extended Triggers

Ok, I am impressed with everything in SQL Server 2005, especially extended triggers to capture DDL actions.  I was playing around with these today and I can see how this will be a nice feature, especially for audit trails.  I’ve included a simple script below. — create sample dbcreate database trigtestdbgo use trigtestdbgocreate table tblextrig…

4