Thank you all, This is what I was looking for too..

Below is the codes I came up with...

Declare @datadir nvarchar(4000)

,@logdir...

I check it via running the below code by logging with the SQL Server service account. Hope it helps you too..FYI, this code checks the group policy value via whoami...

Agreed with Clayman and Matt,

If you think this is something happened automatically? Then you probably have to look at the database options if there is "Auto Close" option set to...

Our On-Site Microsoft support Engineer looked at it and suggested us to failover and failback SQL instance since, changing of default database location requires restart of SQL Server.

Interesting "changing of...

If you have sysadmin access to the SQL Server database; you can simply issue the below command to check all the members of an AD group:

...

I ran into same problem. Because, we block so many permissions through some process. But got resolved after some troubleshooting. Hope any of you still looking for results:

Who so ever...

I am pretty much new to powershell.

I saw this script is quite useful for my environment. If someone let me know how to use this.

I tried couple of time....