Adam

Executing SET SHOWPLAN_TEXT ON will cause a text version of the execution plan to be generated. Just run it before your statement/procedure.

Another option that avoids the sometimes, or maybe mosttimes, problems with SQL Mail is to build your own POP3 email reader. There are a number of examples at http://www.codeproject.com

The BULK INSERT has a table lock option. No need to fiddle with table options which tend to be forgotten once set

http://msdn2.microsoft.com/en-us/library/aa225968(SQL.80).aspx

From the...

Ok, based on the query you provided a non-clustered index on card id won't help.

For the way you're explaining the updates, this is how I see it,

1) first return the...

So why have the CardID column at all?

Why not...

And the query you're using ...

BULK INSERT is the fastest option for importing data into SQL Server. It has most of the options that are available for BCP.

faboudib

I'd like to see the table structure and query before recommending that you have a clustered index on a varchar column.

Jeff

No offense taken as I never thought there was offense meant

Jeff I thought you'd do the math a little better. It's ONLY 158GB

What are you using to produce the numbers you've given us?...

Error seems pretty self explanatory. What login are you using?

How are you creating the publication? via the GUI or via script? If it's via script, can you supply the script?

...

BTW, DDL for table and indexes, along with query and text execution plan are most helpful in providing a complete picture

There are no technical limitations on the number of concurrent processes in the Developer edition. If the server is used in anyway by a "production" process, then there is license...

Kathy, are you using the standard FTP task that comes with DTS? I remember that ww.sqldts.com built an add-on task for FTP, can't remember it's full functionality, might be worth...

Huh ... silly me ... I usually just run sp_helpindex ...