Viewing 15 posts - 1 through 15 (of 2,667 total)
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.
January 2, 2026 at 10:16 pm
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...
December 30, 2025 at 12:07 pm
December 29, 2025 at 5:46 pm
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...
December 29, 2025 at 11:07 am
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...
December 12, 2025 at 6:19 pm
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
December 12, 2025 at 4:03 pm
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...
December 10, 2025 at 12:43 am
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 -...
December 8, 2025 at 10:40 pm
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...
December 8, 2025 at 9:33 pm
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...
December 3, 2025 at 1:25 am
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...
December 1, 2025 at 11:17 pm
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...
December 1, 2025 at 4:52 pm
but main question is why you need a cursor/while loop?
November 8, 2025 at 10:47 pm
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...
November 6, 2025 at 12:46 am
Viewing 15 posts - 1 through 15 (of 2,667 total)