Settings and activity
11 results found
-
15 votes
PeterVandivier_vgg
supported this idea
·
-
6 votesPeterVandivier_vgg
supported this idea
·
-
1 votePeterVandivier_vgg
shared this idea
·
-
5 votesPeterVandivier_vgg
shared this idea
·
-
32 votesPeterVandivier_vgg
supported this idea
·
-
101 votesPeterVandivier_vgg
supported this idea
·
-
46 votesPeterVandivier_vgg
supported this idea
·
-
1 vote
An error occurred while saving the comment An error occurred while saving the comment PeterVandivier_vgg
commented
n.b. this behaviour also occurs with the syntax
```sql
alter availability group [ag1]
modify replica on 'sql1'
with (
backup_priority = 10
);
```Note _including_ `apply_delay` in the above statement does not prevent the error, only _removing_ `backup_priority`.
PeterVandivier_vgg
shared this idea
·
-
3 votesPeterVandivier_vgg
supported this idea
·
-
82 votesPeterVandivier_vgg
supported this idea
·
-
10 votesPeterVandivier_vgg
supported this idea
·
Please note also that removing the "Insert Semicolons" rule still causes the error to throw at the "Apply layout (format SQL)" step. Removing the "Apply layout (format SQL)" step removes the error but then... why would I bother to format ¯\_(ツ)_/¯