In the document it's good.
But when you use the script in the Bin you have to change those parts as you mentionned :
DECLARE @NeedsIndexRebuild BOOLEAN;
Or boolean does not exist in SQL.
New need to write this :
DECLARE @NeedsIndexRebuild BIT;
After replace IF @NeedsIndexRebuild = TRUE by IF @NeedsIndexRebuild = 1
But in the UpdateLogTable.sql, at the line 46 a "SET" is missing.
That's why I put the corrected file with all corrections.
Manu
Hello,
in the next version there will be only one script, something like "UpgradeDatabase.sql" checking and upgrading all tables (log and trend) in a Database.
If you need it before, you should ask Dev or Ref.
- 1
- 2


