I know this is SQL Server Central but another solution would be a script of some sort that runs on the target machine that monitors the file to see if...

Thanks Deepak, I wasn't questioning you answer, just giving the OP another option and explaining to them why they got the error message. Without more info from them on what...

The reason it is giving you the error is because you are trying to assign multiple values to a single row. If you run the SELECT statement by itself you...

It's been a week, did you get this solved?

If not, it could still be permissions since they (the application and SSMS) are being run as different users.

At first glance, yes, 25 million records sounds like a lot, but, and I hate to put it this way but that depends on record size and the actual size...

Is the query slow all the time? I'd start with running the query that running slowly in SSMS and showing the actual execution plan when it completes. That right there...