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, 5 months ago by Lowell.

without access to SQL, no you cannot find out.

if you have access to view server state, the DMV's for index stats has the last time an index was used to...

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

a pair of examples. if you are only looking for items that are 6 chars and start with P, vs stuffing a bunch of zeros into it no matter what...

i prefer the alter authorization command:

ALTER AUTHORIZATION ON DATABASE::[WSS_Content]  to  [MyDomain\SharePointServiceAccount];

i think you need to execute a script after the dacpac deployment.

a dacpac will create tables and objects, but there's no scripting involved, so no, no script can be appended...

holy crap the new format of the website plays holy hell with code i took a lot of time to comment well and make sharp looking.

here is an older example i used to use, that assumes you have a list of server sin Central Management Servers

for each server, i may run a query per server,...

• This reply was modified 6 years, 5 months ago by Lowell.
• This reply was modified 6 years, 5 months ago by Lowell.
• This reply was modified 6 years, 5 months ago by Lowell. Reason: updated to working tested code with query provided

the six month/180 day evaluation is not that painful in a lab.

it is great practice to build machines over and over, join them to your lab's domain, and ideally, you...

oops i missed the variable value request.

you need the data type and the value:

$node.VariableValue.DataType

$node.VariableValue.'#text'