Why yes. That's why I...

Given that there are no instances, I assume there are other things that are not like normal servers.

How does the SAN features (if there are any) work? I'm assuming you...

Is anyone else having a "dot your Ts and cross your Is" kind of a day?

Eirikur Eiriksson (1/24/2016)

---

Here is an alternative method for collecting this (almost the same) information in a single dynamic sql query.

😎

DECLARE @SQL_STR NVARCHAR(MAX) = N'';

DECLARE @OUTER_SQL NVARCHAR(MAX)...

Final, final (we hope working) code for those who are interested.

------------------------------Data file size----------------------------

IF (SELECT OBJECT_ID('tempdb..#dbsize')) IS NOT NULL

DROP TABLE #dbsize;

CREATE TABLE #dbsize

(Dbname SYSNAME NOT...

Jacob Wilkins (1/26/2016)

---

That's going to give incorrect results. For the insert into #alldbstate, you're still joining sys.databases and sys.master_files on the...

Final (working) code for those who are interested.

------------------------------Data file size----------------------------

IF (SELECT OBJECT_ID('tempdb..#dbsize')) IS NOT NULL

DROP TABLE #dbsize;

CREATE TABLE #dbsize

(Dbname SYSNAME NOT NULL,driveletter CHAR(1) NULL,...

Other than me setting a VARCHAR column as NOT NULL in #dbfreesize, I did see the difference between using the local file tables (you'd think I would know better) and...

Yes, because some...

I guess my main misunderstanding here is Tom's use of "'safe harbor' farce". I feel as if I'm missing a specific reference.

TomThomson (1/25/2016)

---

I see the same. Plus in the EU it's probably illegal to host the data outside...

Okay. This is driving me batty.

New code (with datatypes fixed) works fine ....

------------------------------Data file size----------------------------

IF (SELECT OBJECT_ID('tempdb..#dbsize')) IS NOT NULL

DROP TABLE #dbsize;

CREATE TABLE #dbsize

(Dbname...

Luis Cazares (1/22/2016)

---

Brandie Tarvin (1/22/2016)

---

Luis Cazares (1/22/2016)

---

You're using sysname as datatype for your columns. Sysname is by default NOT NULL.

You're effectively not inserting any null values explicitly, but you were...

Luis Cazares (1/22/2016)

---

You're using sysname as datatype for your columns. Sysname is by default NOT NULL.

You're effectively not inserting any null values explicitly, but you were missing the column in...

I understand what you're saying about the SYSNAME, and I agree I need to fix the code.

But if that's the case, why did fixing only the driveletter column, which is...