1
votes

using the below command:

ALTER DATABASE my-db
MODIFY (SERVICE_OBJECTIVE = 'DW300')

but I get

Msg 103010, Level 16, State 1, Line 1 Parse error at line: 1, column: 16: Incorrect syntax near 'my'

escaping with square brackets gives:

Msg 103010, Level 16, State 1, Line 1 Parse error at line: 1, column: 16: Incorrect syntax near '[my-db]'

Similarly with single quotes. How do I do this?

1

1 Answers

3
votes

This query can only be run against the master database on the azure server.

Changing the context to master and re-running works successfully.