ken.trock (7/19/2016)

---

...

I think you said in one of the articles that when a user is removed from AD that their access to SQL Server is instantly gone (assuming they don't...

Andrew G (7/19/2016)

---

Thanks for the script John.

I noticed that @AcctName is not populated at any stage of the script, so the 0x534 logic will not work correctly.

Also, AD accounts and...

Thanks for pointing this...

Steve - thanks for putting in that update. -John.

ajordan 76503 (3/16/2016)

---

I am a new DBA. I read this article and thought you were over exaggerating. Two days after reading this I found this application was stood...

This is the article that I remembered. multiples of 4GB (4096MB) problems in logs. Call me skittish, but I use X000MB increments for everything now. 😀

rick.foster (6/9/2016)

---

HI Can you tell me what source supports this statement? "1024MB and multiples thereof have previously caused problems in SQL Server"? I searched the web and didn't...

Hi - There is another article that describes virtually the same thing and includes database permissions as well.

http://www.sqlservercentral.com/articles/Active+Directory/135710/[/url]

Thanks

John

andrew.leef (2/18/2016)

---

We actually are in the process of converting all of our raw excel queries into stored procs for that reason. If we disallow all but a certain AD...

True, but with the supplied scripts and the...

chuck.forbes (2/18/2016)

---

Using this methodology, I'm still not clear on how you're supposed to limit a user's access to the underlying data, where they can just use an alternative, ODBC-compliant tool,...

Joe: Thanks! I truly appreciate it!

John.

Joe O'Connor (2/18/2016)

---

I did some more experimenting with this, and noted one omission that might be useful - including "is_disabled' in the output. As it doesn't appear to come...

It does show anyone whose access comes in via a nested group. Are you looking for the entire group path back...

AZJim (2/16/2016)

---

My current employment only uses purchased software. I find it amazing how many vendors do not create their indexes with a fill factor (other than the default). ...