i don't believe the permissions are that granular, so I don't believe you can do what you are asking.

AFAIK, there is no owner for a linked server either.

it's very...

why don't you just decrypt the stored procedure instead?

want to use a remote server, but don't want a linked server? I'm with Sean, your dismissing the #1 tool without an apparent reason.

openrowset is disabled by default, whereas linked...

oops

performance wise, this would be a little better, since the OR statement forces a table scan, and this would/could take advantage of existing indexes instead.

but it's effectively the same approach.

SELECT

...

first stab at the issue:

SELECT OrdersTest.*,

CASE

WHEN RTRIM(ISNULL(OrderNo,'')) = ''

THEN 'Blank Order Number'

ELSE

''

END AS OrderNumberIncorrect,

CASE

WHEN ISNULL(PalletCount,0) =...

SQL is really good about not caring about the order of things, the order of columns, the order of data are not relevant to SQL, so having the PK as...

for that specific query, that index is not a good match for a parameterized query

a new index, something like this would probably work immediately for your existing query and...

there's a lot of logic holes in here; are we trying to find the fiscal start date or something? is the 05 date a copy paste err, and it should...

what is the definition of the index?

your query has three columns in the WHERE statement, is the index on all three columns?

since you are doing SELECT *, at a minimum,...

i cannot find it now, but Sean Lange posted an answer to a question that was near identical to this idea, and noted all the grievous, serious problems that were...

well the things i see so far are:

you are joining other tables to a view vw_Return_Entity_Ops

it is very common that a view will grab substatially more columns thyan you...

i have this saved in my snippets; it's calculating the min and max longitudes/latittudes for a specific point, which you then use to bracket in the values search a...

certainly possible, i think it goes directly to your data;

do you have polygon boundaries for your cities, or a simple single point per city?

either way, you can build...

i baby sit a non profit that has a 6000 member email list, and we used send out various notifications just like you plan; the whole one at a time,...