Viewing 15 posts - 34,336 through 34,350 (of 39,800 total)
That's good
.
It does sound a little strange, doesn't it?
December 15, 2004 at 8:01 am
Does Veritas not have a solution? They should connect by instance name, where the ports are resolved by querying 1434 for the port of that instance.
Any reason you don't want...
December 14, 2004 at 9:45 am
If performance is an issue, re work the design or buy a bigger box.
December 14, 2004 at 9:44 am
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...
December 14, 2004 at 9:43 am
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'
...
December 14, 2004 at 9:42 am
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...
December 14, 2004 at 9:39 am
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.
December 14, 2004 at 9:38 am
sp_oamethod @objecthandle, 'Add'
Need a handle the the Jobs object before you can do this.
December 13, 2004 at 7:07 pm
Is 445 UdP blocked sometimes? Are the servers setup on specific ports?
December 13, 2004 at 1:04 pm
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...
December 13, 2004 at 10:39 am
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.
December 13, 2004 at 10:38 am
Are both machines in a domain? If not, I've typically just used SQL authentication to get around this.
December 13, 2004 at 10:21 am
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.
December 13, 2004 at 10:18 am
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.
December 13, 2004 at 10:13 am
Don't feel too bad. The searching functions in MS aren't the greatest.
December 13, 2004 at 10:09 am
Viewing 15 posts - 34,336 through 34,350 (of 39,800 total)