And Thanks Cadavre

Ninja's_RGR'us (10/26/2011)

---

derekr 43208 (10/26/2011)

---

Cadavre (10/26/2011)

---

How's this?

DECLARE @sql AS VARCHAR(MAX)

SELECT @sql = COALESCE(@SQL + '; ', '') + sql_command

FROM (SELECT 'USE ' + QUOTENAME(name) +

...

Cadavre (10/26/2011)

---

How's this?

DECLARE @sql AS VARCHAR(MAX)

SELECT @sql = COALESCE(@SQL + '; ', '') + sql_command

FROM (SELECT 'USE ' + QUOTENAME(name) +

...

Hi Ninja

I tried this

CREATE TABLE #dbs

(

DBNAME sysname

, DBID INT

, [Total Size in MB] INT

, [Available Space In MB] INT

, DriveLetter CHAR(1)

)

INSERT INTO

#dbs

...

Ha Ha - No

Not short at all

I'm just trying to get a 100% percentage accurate amount before I add in the

PercentFree = AvailableSpaceMB/TotalSizeMB*100 column

Hi Ninja

When using the following

EXEC sp_MSforeachdb '

USE [?];

SELECT

DB_NAME() As DBNAME

, DB_ID() AS DBID

, SUM(size / 128) AS ''TotalSizeMB''

...

Ok

So In future, Best practice would be to uninstall any Clustered application before evicting the Node..

So when we evicted the Node - We didn't uninstall SQL

Does this mean that I would have to uninstall SQL and reinstall it using the Add Node feature of the...

Thanks Perry

Thanks

I get the jist of it but not yet confident enough to deploy

I like to understand every single line of the code in the script I use before deploying.

Thanks for...

In a nutshell - What I wanted was to be able to report on the free space in a database as a percentage

With what you gave me, I did this

CREATE...

Done

Ninja's_RGR'us (10/25/2011)

---

I can't see what's on your c drive. You need to upload it here.

If you want you can...

With that

Nothing

Apologies for that - Doesnt look good

Please see attached