So perhaps "VD's"(dare I use that acronym O: ) exist ultimately as a space saver with the trade-off on aggregate result speed???

Anyway - my first attempt was the best so...

Thanks M-

The "Virtual" Dimension seems to be a step in the right direction. However, why create a "Virtual Dimension" rather than a "Real" dimension containing the same Member properties...

OK - got things moving OK.

My "Things to note"

1) Some functions set values to ON or OFF and some to TRUE or FALSE. Very annoying to keep track of.

2) sp_dbOption...

! Perfect !

In the meantime I've tried to set the RECURSIVE_TRIGGER dbOption to OFF.

But, to no avail.

If, in MMC, I go into the Database Properties and into the "Options" tab...

Oopsie - but still have a question...

I have another trigger which fires on INSERT to update a particular column in the same table - my bad.

However, is there a recommended...

No... but an insert(into another table)

To clarify...

Two Tables:

1) People

2) EventLogOfPeopleEdits

Two Triggers

1) INSERT on People

2) UPDATE on People

*NOTE* NO triggers on the Audit table

Whenever the People table is edited (INSERT or...

ya - thanks Steve.

I'm just inserting into an Evetn table now and sending one EMail at the end of the day with All the events.

I'd still like to know if...

OK - this works for the moment.

Only Global temp tables work - not local.

CREATE TRIGGER tU_Update_Notification ON [dbo].[cdAccount]

FOR UPDATE

AS

DECLARE @FileName varchar(30)

SET @FileName = CONVERT(varchar, GetDate(), 102) + '_.txt'

DECLARE @EUser...

Still having trouble.

Seems to have to do with the IDENTITY_INSERT.

The Trigger is firing, but the Identity is not "really" created for/by the Insert trigger.

create table Table1

(

ID int identity(1,1) not null...

Thanks Simon.

Totally side/personal note.

Why do Brits feel it necessary to use their names as much as possible in written expression?

... insert into simon ...

... select * from simon ...

I...

Thanks guys..

Antares:

I think the "Instead Of" trigger fired BEFORE and constraints are avaluated - Need to test but pretty sure.

Simon - I really want the PK column to be a...

There is one and only one problem.

That problem is:

The DTS FTP Task does not report errors when attempting to GET a file that does not exist.

To reproduce the problem on...

THanks but no - go.

1) I need the package to continue since there are more tasks involved.

2) The FTP task does not fail regardless - since it does not error...

Um - duh -

Indexed Views only work with the Enterprise, Developer, and some other version of SQL Server - but not Standard.

So - I could set them up in...

Even more stuff on Indexed Views.

A) It seems that the ONLY way I can specify the correct ANSI_NULLS and (I think) ARITH_ABORT options when creating a View or UDF is...