Perry Whittle (10/27/2014)

---

bbcolo22 (10/27/2014)

---

I have seen many recommendations stating that if you have an even number of nodes, then you should create a fileshare witness (for the 3rd quorum vote)....

Thanks again Grasshopper.

It's trivial, but for failures View-TSQL is clickable, and for successes it is not.

#:7)

Thanks for replying.

In my case, even though I am SA for this SQL instance, that "View T-SQL" button is always greyed out ???

We find that Kerberos works much better (faster and less network traffic to the DC) than NTLM for SQL authentication.

So, for any new SQL Build we always grant these...

How do I see the SQL that is being run by my Maintence Plan Subplan? I am able to view it via Profiler, but there must be an easier...

This could be what the other poster has also... Your example script is different from my situation.

In my case, I just have a login, but no user. This...

I am having the same problem. I have tried every possible grant on XP_REGREAD and XP_INSTANCE_REGREAG but I can only run XP_REGREAD or XP_INSTANCE_REGREAD if I have the SYSADMIN role.

Did...