If performance is an issue, re work the design or buy a bigger box.

I have seen this when a server was under high load. We talked with MS and they said to turn off parallelism. I thought there was a post SP3 fix...

How about this?

update p

set totalapps = b.apps

, totalgials = b.goals

from player p

inner join (

select a.playerid, sum( a.apps) 'apps', sum( a.goals) 'goals'

...

Update the statistics on the table. This can get out of synch. Also, you should have a clustered index on the table (indid =1), which ensures accuracy most of the...

Low end solution, Servers Alive (http://www.woodstone.nu/salive/). I used to use it and it worked great. Drop it on a workstation and set it to alert you.

sp_oamethod @objecthandle, 'Add'

Need a handle the the Jobs object before you can do this.

Is 445 UdP blocked sometimes? Are the servers setup on specific ports?

No, you'd have to set triggers on all tables. Or set a job to go through periodically and just set all data. Be cacreful of logging if you do the...

I've seen it before, but only for SA. We've used the IDS and firewall to block them and trace back, but it usually goes nowhere.

Are both machines in a domain? If not, I've typically just used SQL authentication to get around this.

Are you looking for one database or all? One is easy, all requires some more work to get this to work and return in one result set.

In services, you should be able to set services to restart if they fail. On the recovery tab, you get 3 chances, the last could be to run a file.

Don't feel too bad. The searching functions in MS aren't the greatest.

We're working on that one. Apparently many people don't know what well formed HTML is and with the integration of our top with the forum software, someone's forgotten some tags.

It's...

Great discussions and glad to read about it. Always good to know there are standards out there beyond the PC world. Having worked in mostly non-government shops, I have not...