I guess it simply selected the data from the outside source nad then concatenated apostrophes and commas.  it's nothing you can't handle by yourself if you ever decided to rewrite...

Well first, you don't need to cnovert those to strings, but I'll go along with the exemple.

Why can't you do something like :  Select * from Table where OrderID IN...

... I forgot to say that this is something that can take quite a bit of resources on the server.  So I would really use this on a very unbusy...

Is the service started?

Does the user has permissions to access the server?

What authentication mode are you using??

Can the user see the server (pinging)?

Can you show us a before and after of the column and also how it was used in the where clause?  It's surely something when can rebuild.

You can set up a trace with the system stored procs.  You then tell that trace to run untill 23:59:59.997 PM.  Then you set up a job that runs the trace...

Well a scan isn't always a bad thing.  If you are really inserting every row of the table, then a scan IS required.  However I don't know enough about this...

Sorry I couldn't help...  Did you run the command with the profiler to see what was really going on.  That was my last resort tool when I was working as...

I rarely used DTS and never used SSIS.  I'd suggest firing up the management studio and run the queries manually.  I usually did those checks like this.

Select * from MYTable...

Sorry but this is as far as my experience with this code goes .

I'm sure somebody else will help you figure it out.

Last stupid...

Why do you need to do multiple inserts?

Why do you need to convert the datetime column in the table?  The other way around would allow the server to use the...

Stupid question... Are you sure that you are connecting to the right DB (sure you are)... and are you sure that this usp is in that DB?

Check out the max len of that column... Maybe it's over your threshold.

Also check that you're not losing any data between Nchar and char.

From what you show us.  Only a clustered index on id_s could be usefull.

Is there any other queries run on the temp table?   Can we see the whole table definition?

You can do this for each table... don't know about the whole DB tho...

CREATE

TRIGGER dbo.Tr_MyTable_F_IU ON dbo