I also got the right wrong answer, but that has already been beaten to death.

A side question is how does one get the BUILTIN/Adminstrators login back on the server so...

Please check the code behind the question.

I answerd it correctly - current discussion thread not withstanding (choosing option #5 it will onyl display coumn header).

However the question was marked as incorrect ...

Nope.

I don't have anything fancy. 2 Node Active Passive cluster with a shared SCSI Array. Running a single custom database.

No reason was ever found.

However, moving the group to the secondary node and rebooting the primary node, and moving the groups back resolved the issue.

If the total cost must be updated immediately, this is best done with a trigger. If you can stand a little lag I might consider a job that updates costs in...

Granted the defualt fill factor could be changed, however if you ever plan on taking any Microsoft exam you must always assume default configurations unless otherwise stated.

When I teach Microsoft...

Good Question, bad answer options.

Option A is also correct. Setting the fillfactor = 0 sets it to the default which is set to 100% at installation.

Yup status stays the same.

Reboot both nodes. Same thing happens

Reboot both nodes, left one node off-line. Same thing happens

Tried to initiate a failure. That did not work.

All other resources in the group are online. Users can even connect to the database and run queies.

quote:

---

Try “msdtc –uninstall” on all nodes and also remove the registry keys

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC

HKEY_LOCAL_MACHINE\SYSTEM\Current ControlSet0\Services\MSDTC

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet1\Services\MSDTC

HKEY_CLASSES_ROOT\CID

If you are doing this on a prod, I would...

Sorry. Version Info:

SQL 2000 running on Windows 2000 Advanced Server.

By the way I tried COMCLUST -r but because there is no cluster it won't let me do that either. I...

quote:

---

Assuming this is an Active/Passive cluster, I would do the following:

1. On the Passive Node, take SQL Server offline. Set the Autostart...

quote:

---

What exactly you did, before your SQL agent goes down?

---

I paused the only node I...

Thanks for the reply.

I looked at the EM's Server properties, and "Use NT Fibers" is already cleared.

Thanks for the input.

However, I get no errors in any logs. It's not that the service won't start, it is that it does not auotmatically restart at failover. I can...