Thank you, actually the odd thing is that I RDP to the web-server computer with the same credentials that I use to launch the site from my desktop.

I will take...

I found the culprit!

The Windows locale is different in Server2 from that everywhere else in my environment.

On Server2 it is English/Canada.

On the rest of my env it is English/US.

This affects...

I actually tried a brand new installation of SQL 2008 SP1 Enterprise Ed. on the server with O/S Windows Server 2008 Standard SP2, and while attempting to set the SQL_Latin1_General_CP1_CI_AS...

Perry Whittle (8/5/2010)

---

With locked pages in memory sql server will never release below the min memory setting. It is important to set both the min and max memory when using...

Hmm, I thought if I have locked pages disabled, that I would be able to...

Two advantages of using a dedicated MSDTC instance for each SQL instance are:

(1) Better performance: The MSDTC always runs on the same physical node as SQL Server, minimizing communications overhead.

(2)...

tfowler (7/27/2010)

---

This has been posted on this board multiple times for various reasons, but RSScripter has become an essential tool for Report Sever Management for me. very simple to use.

link:...

Thank you both, that makes sense.

Here is the procedure to fail over back to the original principal server:

(1) Switch mirroring from asynchronous to synchronous mode (if already running in sync mode, no need for this...

As great as "missing indexes" is, it is good to be aware of some pitfalls of the feature:

http://msdn.microsoft.com/en-us/library/ms345485.aspx

Memory pressure may also cause this information to be erased from the cache, so the time frame during which this info is maintained may be even shorter than the latest...

Yup, our support staff looking after AD changes don't like it because it means more work for them, but it seems renaming AD accounts does not jive well with SQL...

S.K. (7/19/2010)

---

Hi Marios,

Has the SQL Instance been restarted at all? My account was renamed, and instances that we haven't renamed yet still link my SID back to my old...

Hi,

We are having the same problem, but it involves the renaming of a single user in Active Directory.

Do we still need to restart the SQL instance to get this fixed?

Would...

Thank you, I'm glad it was helpful.