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

Karen, Gmail and Thunderbird are both examples of clients suppressing images by default.
https://www.wired.com/2013/12/turn-gmail-auto-image-loading-off/ mentions where they changed the default behavior a while back.
I think they have settings...

first, the root of the C: drive, or any drive that has %ProgramFiles% on it is protected, so only users with local admin privilesges can access it.
move your files...

create all your variables you need in your SSIS package.
Pass them to your script task.

then in your code, read them into a variable, assign a value...

gmail has to use port 587 as well as the  use_ssl flag.
here's the exact script i use. replace"sqlnotifications@gmail.com" with your gmail address instead.
--#################################################################################################
-- BEGIN Mail...

you'll need to re-save it as a lower version.
with Visual Studio, create a new Reporting services project.
add an existing item with the specific rdl in question.

right...

here you go, here is one way:
i just used a case statement to examine the fifth character, to determine where to start the substring:
/*
ActualValue  ExpectLeftValue ...

Beating my own drum here, but i put together a procedure that queries the metadata to script tables and objects:
I try to maintain it as best I can, it's...