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

your example was not syntactically correct, i fixed it for you.
the key you want here is to group by and SUM.
some things just don't belong in the results,...

SearchAllTables from stack overflow explicitly ignores date/datetime datatypes.

peek at the code:  

modify your version to use datetime data...

in SSMS, if you drag the columns folder from the SQL object explorer to an ssms window, all columns will appear as a comma delimited list.
it's easier then to...

SQL doesn't have a rowtype equivalent.
ROWTYPE , in sql terms for me, is used in a cursor as a collection of all the @parameters that would correspond to each...

We have an Audit in place that captures Login created or Login Changed.
I have seen on patch nights, those same logins get dropped and recreated as part of the patches;
i...

it's gotta be permissions.
here's my suggestion:
On the  SQL Server, Create a credential that has your actual username and password, because we know it works when you execute it.