This old post helped me today.

Thank you.

@homrebrew01

you are right. Even same 2019 versions giving me an error on some servers and some servers it's working fine and sending an alert. something fishy going with the script.

Let...

Thank you everyone for valuable input.

way back I found the script TechNet Gallery but not seems it's got moved or removed. I will try to make it work and post...

I apologize for the late reply. But This is what I get from the code I ran as per @homebrew01.

So the solution with new changes...

Thank you for all suggestions. The solution got fixed by this change.

SELECT DRIVE, SUM(CASE WHEN INFO LIKE 'TOTAL # OF BYTES : %' THEN CAST(LTRIM(RTRIM(REPLACE(REPLACE(SUBSTRING(INFO, 32, 13),...

Thank you Ratbak,

SQL 2012 and 2019 is totally different. I am testing this solution on SQL 2019 LAb/Test Machine.

I ran the query I received below error after words. Looks like...

Thank you for your time to look into this question. I believe this part of the code is throwing an error.

SELECT DRIVE,

SUM(CASE WHEN INFO LIKE 'TOTAL # OF BYTES :...

Hi Derlith,

I am also using this script and very handy. I am looking for same script also shows 'Disable' if any jobs are disable on server. do you...

One of Best Reply from Ed

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/31bf6ae3-c116-4569-9202-4160a0d3d763/raid-level-configuration-best-practices?forum=sqlsetupandupgrade

SQL Data File(s) --> Raid 10 or Raid 5

SQL Log File(s) --> Raid 1

Tempdb Data --> Raid 10 or Raid 5

Temdb log...

I am facing same problem did you find any work around?

Hi Alan,

thank you for detailed information I really appreciate your time to write in more details.

So according to User Prd and QA database Size was pretty much...

Hi Jeff

Re-Org Index and Update Statistics job running Every night

I am running this command .

SELECT * INTO #JobInfo FROM OPENROWSET('SQLNCLI', 'server=(local);trusted_connection=yes','set fmtonly off exec msdb.dbo.sp_help_job')

this runs for other connections but somehow its throwing error for one Instance which is...

This is Error when I am running SQL Command on destination Server

OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Login timeout expired".

OLE DB provider "SQLNCLI10" for linked...

1.) Network path: Is there a path available to the server across the network? Have you tried to PING the server? Can you connect to the server from the machine...