Brandie I've always done something like this to keep it Sarg-able; does that help? it's an OR, i know, but it would allow indexes to be used if they exist...

ok  more info for everyone.
I scanned all 100+ sql instances in my Central Management Servers.
I have seven servers that have a variance of over one day. one is...

That is the funny part of this dilemma Sue;
I also found references that systeminfo can be incorrect.
in this case, it is the value from sys.dm_os_sys_info that is incorrect.

these...

here's an explicit string array declaration example for powershell:
MyServers=@("VMSQL01","VMSQL02\SQL2016","AnotherSrver\ETL")

it's not a one line query, unfortunately.
SSMS opens a query to each server, executes it, and aggregates the results.
You will have to do the same, and it's a...

I do something similar, where i loop through a table full of queries, execute them on a server, and capture the results in a dataset, which is then pumped out...

ALTER ANY DATABASE expects a [login] as the target, and not a database(user) role.

don't forget the basics: make sure you've added SET NOCOUNT ON at the  top of your procedure, as well as commenting out any PRINT statements.
those add some added overhead...

I got it to work as expected by using a SUM(case..) format, with a group by.

My ending date might need to be changed, as i seem to be...

this  is a great example of testing it yourself, using EXECUTE AS can let you truly visualize and understand permissions for a user

say mydomain\lowell is the guy you...

Alejandro I have pondered this over time,and there is a difference between informational reports and exception reports for me.
An informational report might have lots of info, names of databases,configuration...

I've gone through the effort to get some certs,and i will not bore anyone with the alphabet soup.
My feelings are mixed.

I'm an experienced DBA.  For me,The lower...

your WHERE statements are using functions on a columnName, LIKE statements and OR's, which eliminates the ability to use indexes, so all tables have to be scanned.
you are also...

your SQL server could be unresponsive due to high CPU or something, but some memory is always reserved for the Dedicated Admin Connection(assuming it was enabled), so if a server...

are the packages using dtsconfig files, or do they all use embedded connection managers?

either way, you can use an SSIS package and some script tasks to scan for...