let it run - but don't do 100mb chunks. do 50 GB or 100 GB each time.

but it will take a long time to run for sure.

the server where it works is it a Named instance or default instance?

and my advise, for multiple reasons, is never to use the powershell from SQL Server and instead use...

check https://sqljana.wordpress.com/2019/03/08/ssas-automate-ssas-backups-with-powershell/

use a powershell script instead - you can get all db names, and then do backup https://learn.microsoft.com/en-us/powershell/module/sqlserver/backup-asdatabase?view=sqlserver-ps

one other possible option is to have a job that updates the xmla of...

• This reply was modified 1 weeks ago by frederico_fonseca.
• This reply was modified 1 weeks ago by frederico_fonseca.

hum... using that with SSIS would be a big no no for me - why use a cloud thing for local processing (SSIS is local to server) - if you...

have a look at this thread - I've posted good info about using the free winscp to do what you need.. from within ssis.

https://www.sqlservercentral.com/forums/topic/ssis-sftp-using-winscp

error is clear - client does not support connection encryption.

change the connection strings to ensure that encryption is optional and trust server certificate. or follow required steps to fully enable...

does not matter what tool you use - you talk about a "reporting application" - as it does not take a text field, then datetime is what you use -...

SSMS will show up whatever format is defined by you/ your locale.

your reporting software is what needs to do the formatting to UK format, not your sql, neither what you...

2 beers.. you triple posted

original code has been subject to an incorrect replace somehow.

but it should have been easy for you to identify where an alias is missing and which columns refer to it...

you mentioned ETL - depending on the tool (SSIS for example would require this) you may need to open each of those packages and regenerate column definitions.

what/how and IF depends...

best practice is to grant required permissions only, and not to add to local admin.

If the install of the instance is done with the correct type of user, all those...

but main question is why you need a cursor/while loop?

the reason why the code was removed (post deleted really) is because since sometime ago any post that contains 2 URL's gets that treatment. there is no error, just normal...