Absolutely -- I do see a use for triggers in auditing.

My argument was based on the use of triggers to implement business logic and to do the sort of data...

Gettng paid to pontificate on beer...that's a really nasty trick.

I'd like to say I'd never have fallen for it...

Tony.

Apologies to all who experienced some difficulties with this crossword. We're investigating what might be the root cause of the "virus" problem right now, and I'll report back.

We'll post the...

I'd like to thank everyone for their responses. Of course, there is no single "right answer" to either of the dilemmas posed, but I...

I think that option 3 could be worded a little better.

Instead of "Add the Event Subclass to your trace", it should say:

"Add the EventSubclass data column to your trace"

Tony.

Hi Michael,

You weren't imagining things -- the article really wasn't there. It was one of the legacy articles that was multi-page. These articles aren't supported on the new site, so...

It would certainly help my average!

Seriously though, apologies for the mistakes made in today's and yesteday's QoDs.

Tony.

The new RDLs are now in the code download.

Cheers,

Tony.

I've got a degree (BSc) in Chemistry, and even went as far as to get a PhD in the subject.

I'd like to say that I use what I learned there in...

Hi,

I've reported this and will let you know what we find ASAP.

Cheers,

Tony.

Thanks for reporting this -- we are investigating it now.

Cheers,

Tony.

Pasted from SSMS into design window using admin interface:

USE [master]

GO

CREATE DATABASE [Test_DB] ON  PRIMARY

  (

        NAME = N'Test_DB',

        FILENAME = N'D:\MSSQL\Data\Test_DB.mdf' ,

        SIZE = 102400KB ,

        MAXSIZE = UNLIMITED,

        FILEGROWTH...

This is pasted from the Rendered HTML tab of the prettifier into the Design window. When I initally paste it in to the editor, it adds in extra carriage returns...

Phil,

1/ I pasted the code below from the HTML tabe of the Pretiffier into the HTML tab of the 
editor (not available to non-admins) and edited it 3 times

USE 
 

Steve,

I never knew you were a backgammon fan! I'll have to give...