Not an outer join, right? You just want something returned?

Can you give a result set example of what you'd want here? Is it just the first 2 columns with null...

Read that article, and then give us some DDL For your result set and some sample data as insert statements. We can help.

I'm with Gail. If it's too resource intensive for your workload, run the physical only on the servers. However, make sure you restore a backup and run the full DBCC...

The pros:

You can easily repeatably execute queries against all servers (except the CMS, though there's a workaround). This is very handy for administrators that try to standardize and manage servers...

steve.neumann (1/22/2014)

---

this article made me laugh. there is rarely a day where you do not have some sort of grammatical mistake etc. there's even one here...

..."and possibly impress someone else...

I'm not 100% sure. I know it uses Kerberos, and should connect to a DC. I've seen some strange issues where I've had to use DC/AD tools to reset the...

Try this, go into the local host (Windows) and try to add that user to a local group. Same spelling.

I wonder if you have some DC/Kereberos issue between the...

Aha: http://www.sqlservercentral.com/Forums/Topic1511837-391-1.aspx

Let me dig around.

chrisn-585491 (1/22/2014)

---

I'll...

+ 1

You can also make sure that your read only files are mostly full. I saw a technique...

Saw this from Grant: http://www.b-list.org/weblog/2008/jul/28/lets-talk-about-dvcs/?utm_content=buffer84cfc&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer

Interesting reading.

There's no replication from SQL to AD. SQL Server has to query AD to verify the account.

I'm guessing you've spelled something wrong, or you need to include the domain. Can...

Do you have Enterprise Edition? I'd data compress first.

However, compressing the disk can work. Can you give more information on your setup and sizes? How much data growth is there?...

I dislike disk compression for this reason.

Thanks for the update and glad you solved it. Out of curiosity, did you check properties on all subfolders or use some other method?