Home Forums SQL Server 2005 SQL Server 2005 Integration Services Stored Proc with temp table issue. RE: Stored Proc with temp table issue.

  • May 26, 2013 at 12:57 pm

    #1618616

    create NONCLUSTERED INDEX #idx_ID on #TID(ID) include (TID)

    hmmm. the create index is for a temp table I don't see referenced anywhere else (I see #ID and #EID)

    Can you remove the create index statement from the sproc and try rerunning the bids package.