Without a tool what are the options.

We have atleast 200+ instances and I would like a report which states whether the windows box is pingable, if the sqlinstance is...

do them on a per table basis if deemed needed -...

dup post - see replies on https://www.sqlservercentral.com/forums/topic/destination-table-condition-amount-0-3

again you keep failing to address how to ask for help here - and again you fail to understand that on this case only you can see what is wrong...

dup post - see replies on https://www.sqlservercentral.com/forums/topic/destination-table-condition-amount-0-3

• This reply was modified 1 year, 2 months ago by frederico_fonseca.

That article is for SQL 2008. The servers are 2017 and I'm pretty sure SMO code doesn't work anymore in 2017.

EDIT: Even looking at the PowerShell options, it doesn't...

easy with SMO

https://www.mssqltips.com/sqlservertip/3675/using-smo-with-powershell-to-obtain-sql-server-job-information/

you just need to create a list of servers to extract from and do a foreach loop on that list to call the job function.

use it all the time - and our DBA team has a central server with CMS setup so it is available to all DBA's (and some snr developers/architects) as well.

in...

for that you will need to have a audit log table and a trigger on the table you need to monitor- no other way to do it (other then perhaps...

• This reply was modified 1 year, 2 months ago by frederico_fonseca.

have a look at this https://www.sqlservercentral.com/forums/topic/sqlagentreaderrole-can-create-its-own-jobs-what-is-ms-thinking

SQLAgentReaderRole would be the role to use to allow them to view jobs - but as this gives also permissions to CREATE jobs a few...

not those settings (which should be changed in most occasions - just don't set it to automatic on newer version of SSIS)

look at https://learn.microsoft.com/en-us/sql/integration-services/data-flow/ole-db-destination?view=sql-server-ver16

setting can be applied on the execution of the script itself - changing global policy is bad - but changing to execute a internal script with the setting on is...

please do not create duplicate posts - you have already posted this (see https://www.sqlservercentral.com/forums/topic/updated-table-not-displaying-data) and you have gotten several replies - fact that they are not what you want (e.g....

get them properly formatted.

what you gave us is on a single straight line - so its unusable.

but I do have to say that if this is not giving you what...

likely you doing it incorrectly.

following works fine with SSMS 19.0.

2

where contents of the script is just a straight "gci c:\"