i got the answer from your doc, thanks!

the data source is on DB2, which i don't want to modify, that's why i download them to SQL by SSIS.

thank you everyone, i will try to create an clustered...

you are right, 10 rows been deleted insert every min.

the reason I do so is, i put all 'open' PO into this temp table, keep updating the status\details of each...

thank you , guys:

1. there is no index on this table. because it has been deleted\inserted all the time, and only about total 10 records there, i didn't see any...

thank you all for helping me.

this is the answer I needed.

dev pc is windows xp 64 bit, and the server is windows 2003 + sql 2008 sp2 (default code page, SQL_Latin1_General_CP1_CI_AS).

thanks, everyone.

When you put a 7/24 business on the cloud. How any days you could lost to rebuild an in-house data center when your cloud provider having a trouble? Guess the...

As a financial company, we rather lock all the data in our server room than put it on internet. An old style lock could stop any hacker.

Plus , the...

i found the same issue on MSDN, seems 'a file that sometimes contains an extra CRLF at the end of the file' cause the problem.

but not solution yet, last post...

never mind, i am going back windows xp, same PC with XP works fine. don't want to waste any more time on this.

Windows 7 just a fancy thing in office...

yes, it SHOULD.

i have another windows XP. ssms2008 has no problem connect to sql2000/2008.

but this windows 7......

i can't register the server as system DSN since my win7 pc can't recognize the server. however, i can ping that sql2000 server.

i tried to use ip\instance name (in both...

thx!