documentation clearly states that any date conversion to be deterministic needs a deterministic style specifier - '19000101' didn't had it

its a separate install - download from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

it may be because of the implicit date conversion.

try the following - but change the convert(date to be the same datatype as the corresponding start/end_date field

ALTER TABLE...

• This reply was modified 5 years, 9 months ago by frederico_fonseca.

I would say it was setup incorrectly - the DB engine is the one that should have the SPN's.

As Sue mentioned download the tool and follow its recommendations

I assume you meant export-DbaDbTableData

could be done...

• This reply was modified 5 years, 9 months ago by frederico_fonseca.

sample powershell script that I use to copy/move files from a drop folder to dev/tst/prod destinations - dev/tst are "copy" while prod is "move"

some of the functions called are in...

ARGHHHH.. Sorry Jeff - hit report button by mistake.

your question - can powershell use variables - not exactly like you do it on a storedproc - but you can query...

really annoys me when people don't even bother searching for what they need.

hana studio and Hana client are required - you get those from SAP

first link google returned...

someone has changed the default value to 2048 - unless someone experienced has tested and determined that this value is the best for your system MS recomendation is to set...

really annoys me when people don't even bother searching for what they need.

hana studio and Hana client are required - you get those from SAP

first link google returned https://blogs.sap.com/2016/08/05/how-to-connect-microsoft-ssis-with-sap-hana/

yes you...

use powershell for that - easy in just a few lines.

see https://powershell.org/forums/topic/find-and-replace-strings-in-multiple-files/

Frederico, do you have any test case to support your speculations?

I (and I guess Jeff Moden too) would be particularly interested in a test script which demonstrates advantages...

again some basics - few options to do it - and not exhaustive for sure and if anyone has a "faster" method please supply it and i can test it...

• This reply was modified 5 years, 9 months ago by frederico_fonseca.

I should not have had the need to do this - all the links that I supplied have this info one way or another and more.

small test case - 5...

the paper i mentioned does give some insight to what happens under the covers - I could not find their previous paper and that would give even further insight to...