SQL-AI-samples icon indicating copy to clipboard operation
SQL-AI-samples copied to clipboard

Correction and Need more details as Testing Stuck

Open spotakash opened this issue 1 year ago • 0 comments

Import needed CogSearch functions"

This keeps on throwing error with message ImportError: cannot import name 'QueryLanguage' from 'azure.search.documents.models'

Bit more details to be added to match perquisite in order to test it successfully

"### Enable change tracking\n",

Correct code is this; try: cursor.execute(f"ALTER DATABASE [{database}] SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)") except Exception as e: print(e)

because code provide keeps on throwing error ('42000', "[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near '-'. (102) (SQLExecDirectW)")

spotakash avatar Feb 13 '24 11:02 spotakash