GRANT SELECT, UPDATE, INSERT, DELETE, ALTER ON [schema].[tablename] TO [username];

Could be that the index on Modified_date is not selective enough. Or, that statistics are outdated and the optimizer just thinks that it is not selective enough.

Try sp_updatestats to see...

Input parameter validation and TRY...CATCH blocks are a great start

From the docs:

"A return code of 0 means success. Any other value means failure. The error code for the statement that failed is stored in the @@ERROR variable."

That really means...

Thank you!

Thank you for the reply.

The issue is that the underlying tables are indeed on separate instances.

The distributed partitioned view references tables on two servers (will be 4 in production).

Accessing the...