Huh? I don't mean SELECT *

I mean solve the general dependency / refresh problem in...

Wow, you beat me to it and with 10 less lines of code

I made one adjustment to your code (in the order by)

ORDER BY ABS(CAST(DATEADD(MINUTE, ROUND(DATEDIFF(MINUTE, 0, DateVal) / 60.0,...

I wrote a tool for this type of dependency refresh problem

it calculates the dependency graph for a group of changing objects

and generates the correct dependency-aware script to refresh the objects

it...

I have only dabbled...

oh yes, good call - I never noticed they were deprecated, I was always fond of those

I don't use component services / mts etc. but

if sp_bindsession is gone that means...

you could use

sp_getbindtoken and sp_bindsession

and get access that way

can't see a good reason to though

You need to determine EXACTLY what is taking the time

I don't see any evidence of that determination in your post

Without a clearly defined problem there is no point in thinking...

and visibility

#temp is only visible to the current session / connection

temp is visible to all sessions

are you using this approach?

exec [server].[database].[schema].[procedure]

The text of the query time out error might be useful also

I also discovered:

- sql server remote query time out

- linked server query time out

-...

I think it is related to permissions

try changing MSSQLSERVER service login to "Local System"

on my box the problem went at that point

I still haven't located the exact problem yet -...

I think the username must be an identifier

that means not a variable or string literal

CREATE LOGIN superman -- OK

CREATE LOGIN 'superman' -- NOT OK

CREATE LOGIN @superman -- NOT OK

one of...

My 2 cents

I never yet saw an automatic failover solution that made a good determination when to failover

I prefer for a fast manual failover

All servers are configured to perform all...

provide a users explorer - one record per user

link to rights explorer one record per right filtered by 1 user

then provide a rights explorer - one record per right

link to...

there are different time outs:

- connection time out (failure to open connection or receive handshake)

- command time out (failure to receive response from open connection)

- lock time out (failure to...

if his post was a genuine attempt to contribute then I apologise

otherwise I can not apologise sincerely