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 6 years, 3 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 6 years, 3 months ago by Lowell.
• This reply was modified 6 years, 3 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 6 years, 4 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

            
            
                                                
        

connectionstrings.com suggested a slightly different syntax, but both are valid:

https://www.connectionstrings.com/mysql/

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Connection Timeout=5;

i think you can just modify the connection string in your shared data source.

by default, it looks something like this, just a servername and a databasename, but you can modify...

it depends on what you are after. one of the most common requests is to change every  other row for readability.

an example:

https://www.mssqltips.com/sqlservertip/3490/alternate-row-background-color-in-sql-server-reporting-services-tablix-and-matrix/

so in that example,the rownumber*() function needs teh...

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