Duh never thought of simple, I did get a nice trigger that works but your way would have been faster. My trigger is at least flexible enough that it...

the problem is that these steps are either large sp's or SSIS error will not always be the same

have you tried installing .net 4.0

thanks would this be applicable to 2012?

is there a way to limit the memory of this 2nd instance of OLAP. I know how to do this in the database engine side, but how can I...

that part I get the issue is how do you scheduled the piece to renable. I do not want it to run at a 2 AM the first time,...

He commented you could keep the identity column. If the table already exists and just copying data between databases can you keep the identity value from the originating table?

is there a choice to keep the identity value ?

the source is hl7 sending messages to sql server tables for processing

trust me not my idea, bad development

did was just the normal stuff, it was like a quick crash, there was some network IO packets backed up checking into that

no maxdop issue, ran sql against all DMV's looking for anything even have Idera DM running against it, issue went away not to be found

problem is with data like this (my bad should have included it)

1233IL

22M33

Would exclude 2nd record

wont happen, the records with the 2 characters at the end are state abbreviations added on

Yeah a great reason to go to 2012 I know of several people who bought monster box for 2008 and now are stuck with extra memory unless they have a...