Another option is available if you have sufficient information stored in AD anyway: Qyery Based Distribution group. This group does not have any members, but enumerate those matching the LDAP...

Inspired by this thread, I've tried to wrap up the discussion on my blog, including a similar but interresting scenario: two sites. Any feedback is more than welcome.

The discussion in...

First thing that comes into my mind, a data driven subscription where you have a query that checks for any reconds that would be included in your report.

That the server is not running anything else does not mean that you don't have an IO isuse, and these issues comes in all flavors. One I have experienced is...

Just curious, is this since associated statistics is updated?

Nothing in SQL Server Error log either?

If I understand your requirement correctly:

RIGHT('0'+LTRIM(OrderPeriod),2)

Can you please post the error message you get?

If the object is already created, I'm afraid that information is lost already. However, for new objects you may implement DDL Triggers or Event Notification. DDL Triggers are the most...

As said, yes: Resources may fail back and forth over time, and that is the whole purpose of a cluster. But, you barely touch an important area here. How about...

By the way, if we stick to your scenario, the location of witness doesn't matter, you're screwed 50 percent of the time anyway. But, you are aware that SQL server...

steve smith-401573 (12/13/2011)

---

okbangas and dev,

The mirroring is established between virtual servers. The question could be analogous to three physical servers, but two of the three servers share a single...

Especially IPv4-mapped IPv6 addresses, like ::ffff:192.0.2.128 🙂

For this you either need a column with the month in something like ISO format, eg 201103 for March 2011, or you need a colum for year and a column...

Honestly, I don't know. But, I suspect that you may have a typed xml column, and that the error is related to the schema in one way or another. Does...