Hi,

Thanks for your reply.

But I want to know that when drop down for parameter,there is default value " " which is system added,Can we change that??

Hi,

Thanks for your reply.As removing trim functions,query is working fine.

But we found one more problem -

Query -

Update JV_INVOICE Set Paid_Flag = 1

Where SOURCE_SYS_ID+ACC_NO+INV_NO not in

(Select SOURCE_SYS_ID+ACC_NO+INV_NO from...

The suggestion of removing trim functions did a great job for us....now the query run in 30 sec instead of 20 mins ...Great ..Thanks a lot for suggestion. But my...

Thanks for your suggestion..we will keep you updated with the status as I am going to implement your suggestion...Thnaks again...

Damon Wilson,

Thanks once again for your reply.

This time i followed same way as you suggested.I have executed query,and start for trace file.Then through DTA,i got some new index script.I...

Damon Wilson,

Thanks for your reply...

I have tried a way that you suggested.As i used Database tunning adviser,it suggests to remove all indexes.I followed same way.But yet it did not work.I...

I have checked tempdb size.Even i changed it to 2 GB from 1 GB.But still problem persist.

Do u have any idea??

Thanks for your reply.

No,in Management studio i don't have problem.

But in DTS problem exists.If you have any solution please inform me.

or where are you going to serach this solution??

Thanks for your reply..

Yes i am going to re-install SQL SERVER 2005,where reinstalling it ask for collation setting,that you can set.

And i am going to set according to my database.

Hope...