Also note these table are in 2 different databases, I didn't indicate that in the statement I originally posted.

Here is execution results of the queries you sent, I modified them...

GSquared thanks for helping with this.

We are on 2008 R2 Ent.

here are the table and index defs

CREATE TABLE ADMStage.[dbo].[EventReference] (

[EventGuid] [uniqueidentifier] NOT NULL

,[DateKey]...

Ok, I've attached 2 plans, the original (plan1) and a second with the where condition removed (plan2)

If anyone is interested here are the rest of the pieces...

I use the stored procedure (below) to load this table. then I export the table to Excel (using ssis). We...

Thanks for the help everyone.

Here is my modified SP using dynamic sql for entire statement, works much better, although I'm not sure why I need the commit but without it...

got it, little slow today I guess.....

Ok, what is MAX DOP 1 ??

Ninja, that makes sense, just like what I stated a couple posts above regarding Adi's post.

declare @SqlCmd nvarchar(200)

declare @Database varchar(200)

set @Database = 'tempdb'

SET @SqlCmd = 'Use ' + @Database + ' PRINT db_name()' --should show tmpedb

...

Ok, here is the whole procedure

Error:

dbo.messagemask.columnMapping...

Thanks for the help, obviously my understanding of nvarchar(max) was not so good. I get it now, guess I've never run into this before.

Ninja, what do you mean by post DLL?

Sorry nevermind, didn't read properly

Lowell,

That appeared to work, I'm confused now, when I do the print statement I only get part of the definition, but the execution works.

Is Nvarchar(4000) the same as Nvarchar(max)?

that is what I am currently using, the variable name is @ViewDefinition, this is the variable that gets executed, it's too small and cuts off the view definition so the...

no errors tried all options, not going to set trustworthy on as that blog suggests. did everything else nothing.

So i just put the stored procedure call in my SSIS...