It is a great script and I modified your script below.

Select

volume_mount_point,

CAST(ROUND(max(vs.total_bytes)/1024.0/1024/1024, 2) as numeric(16,2)) TotalSpaceGB ,

CAST(ROUND(min(available_bytes)/1024.0/1024/1024, 2) as numeric(16,2)) FreespaceGB ,

Count(*) as DBFileCount

from sys.master_files S cross apply...

A nice script.

2 cents

If you run this script against SharepPoint database, please increase the following two variables.

1. DatabaseNameVARCHAR(250)

2. ,@vcDatabaseNameVARCHAR(250)

Thanks

Very nice script!

Thanks

Weird, at this time, I revoked those permission after I deny.

use [master]

GO

REVOKE ADMINISTER BULK OPERATIONS TO [NCLPROD\spdfarmadm] AS [sa]

GO

use [master]

GO

REVOKE ALTER ANY AVAILABILITY GROUP TO [NCLPROD\spdfarmadm] AS [sa]

GO

use [master]

GO

REVOKE...

I found the "VIEW ANY DATABASE" permission was dropped for some reason.

But when I ran to add it. The command below was successfully completed.

GRANT VIEW ANY DATABASE TO [NCL\SPDFarmAdm];

But when...

Thank you, GilaMonster, for your quick response.

Yes, I ran the "DENY" command.

use MASTER

go

DENY SHUTDOWN TO [NCL\SPDFarmAdm];

DENY ADMINISTER BULK OPERATIONS TO [NCL\SPDFarmAdm];

DENY CREATE ENDPOINT TO [NCL\SPDFarmAdm];

DENY CREATE AVAILABILITY GROUP TO...

The output looks pretty good.

Thanks!

Surprise, people still use bcp. I love this script.

Could you please give me an example of the serverlist.txt file?

Thanks,

Ray

I am waiting for your new version.

Thanks again!

Ray

Looks like your script doesn't include MS SQL Resource database.

32767 data C:\Program Files\Microsoft SQL Server\MSSQL10_50.DEV\MSSQL\Binn\mssqlsystemresource.mdf

32767 log C:\Program Files\Microsoft SQL Server\MSSQL10_50.DEV\MSSQL\Binn\mssqlsystemresource.ldf

Nice sql script. It even can pick up those long funny database names of SharePoint.

Thanks,

Ray

What a surpprise! Your script even support those funny long name of Sharepoint database.

Execellent job!

Thanks,

Ray Wang

A nice script!

Thank gcs_dba. You fix my problem too.

A nice script.

Thanks