if there is no server name, then it is implied that the database exists on the local server; is that how it was set up originally? if you can find...

Classic ASP often made use of include files, so as Sue_H suggested, you just need to search the files for the database/server name and zoom in on possible locations to...

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...