This is a handy guide to querying LDAP from SQL Server (and other places).

The gist is that your SELECT statement needs to include the full LDAP://OU=??,DC=DOMAIN,DC=COM path as the FROM...

As per this little message buried in the Supported Version Upgrade Paths documentation, it looks like you could be out of luck:

* Microsoft support to upgrade from release candidate software...

simonsmithbsa (1/5/2017)

---

We have a database that has been designed to service the application - currently there is no real reporting database, reporting is done off a replicated copy of the...

Does the restore spend a lot of time at 99-100% complete, or a long time at the beginning (0%), or is it slow throughout?

If it's taking a long time to...

I dread to think what a DDOS attack mounted by...

I have previously done a blog post with a query that allows you to see which backups were part of each backup job[/url] - this can identify databases that haven't...

Back to work for a bit of a rest? 🙂 Have...

Revenant (1/1/2017)

---

Future ...

y'know, that was my first answer... but I censored myself...

Things like "WITH NOLOCK" are called "Table Hints". You'll need to put them next to each table you want to apply them to.

But note the drawbacks of NOLOCK -...

Much more concise; runs quicker / more efficiently; returns the same number of rows. I just can't quite see *how* correctness is guaranteed (given the nature of the data),...

Peace

...and I hope that's earwormed you with Paul McCartney's Pipes of Peace.

I expect there are far better ways of doing this, but here's a first pass:

WITH Postcodes AS

(

SELECT

Postcode ,

...

I was disappointed that there wasn't a picture of a crowd with Steve hiding in it while wearing a red & white striped jumper and a bobble hat...

What is this, a free consultancy?

http://www.sqlservercentral.com/Forums/Topic1846082-2799-2.aspx

Strewth. Where's my popcorn?