Unable to deploy the IndexOptimize script in Azure Sql server #441
Unanswered
rajeshpalo2003
asked this question in
Questions & Answers
Replies: 2 comments
-
|
It is not supported to create objects in the master database, in Azure SQL Database. You need to create the stored procedures, in the individual user databases. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
But if you have a Azure SQL using an Elastic Pool with multiple database in it, you need to run the script: IndexOptimize.sql in all these database ? |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Unable to deploy the IndexOptimize script in Azure sql server which is managed by Microsoft. I'm getting below error.
Is there any other approach to deploy? Or do we need to deploy this in individual Azure SQL Databases?
Msg 262, Level 14, State 1, Line 9
CREATE TABLE permission denied in database 'master'.
Beta Was this translation helpful? Give feedback.
All reactions