Unfortunately, unless you have set something up previously, this is not possible. No default setting captures that level of information, as the log would probably exceed the database size.

also, no-one...

dtexec /Server "SERVER-INSTANCE" /envreference "DEV" /isserver "\SSISDB\Sample\Sample\pkg_Sample.dtsx" /par "$ServerOption::SYNCHRONIZED(Boolean)"

the red part i highlighted is the definition, and not the value, isn't it?

i think it is supposed to actually also...

your issue is ISNULL and implicit conversions.

ISNULL(NumericColumn,'') fails because numeric column can never be empty string  (the value of '')

the isnull function is attempting to cast the varchar value of...

• This reply was modified 5 years, 4 months ago by  Lowell.

are you sure you are sysadmin on the server? the error implies either the spelling of the trigger is incorrect, or you do not have permissions.

if you have view any...

• This reply was modified 5 years, 4 months ago by  Lowell.

on the SQL server itself, someone has created a logon trigger on all server.

that trigger is preventing the login...it might be doing it on purpose, or it might be an...

• This reply was modified 5 years, 4 months ago by  Lowell.
• This reply was modified 5 years, 4 months ago by  Lowell.

looks like although it has a lot of moving parts to set it up, there's a decent article from Ms to help with the walk through:

this link is for SQL2017,...

i think you are targeting the wrong tool.

you want to use an SSIS package to pull data from SQL, and let that do the HTTP post.

SQL, by itself, does not...

so the scale out deployment will distribute the reports executions out to the SSRS farm, which is great if you have lots of calls to the reports. I would expect...

blindly updating is not a solution, as mentioned, but you can at least review the data and make plans accordingly.

from the metadata, this query generates the queries to compare the...

• This reply was modified 5 years, 5 months ago by  Lowell.

I updated my original code sample with one I have just tested. it outputs data the way i would expect now.

I am using a stringBuilder instead of a DataTable to...

NOT IN doesn't work the way you might expect if the column tested  has any NULL values.

you'll want to exclude them explicitly.

WHERE SoftwareTitle NOT IN
(SELECT Software FROM...

once assigned, i think you have to Shift + Right click, and then choose open With...

the dialog has the option to set the default application near the bottom.

you'll just need a loop that iterates per server

the question is where the list of servers comes from, here i have an example of populating form a query, but you...

i think you should have gone straight to the source.

https://ola.hallengren.com/versions.html

09 Apr 2018

Added support for Linux and Amazon RDS in the job creation in MaintenanceSolution.sql.

look specifically at your row number function. if you are getting duplicates, identify the column that causes duplicates, and add it to the partition by of hte row_number() statement:

            
June 11, 2019 at 2:11 pm
            
#3652323