Issue while creating user for a specific database through code in Azure

Question

I am creating a copy of database in Azure through c# code.

Code for creating database:

CREATE DATABASE ABC AS COPY OF DEF

Then I want to create a user in that database so that only that user can access the database. This code executes as soon as the database is created. but while creating a user I get an error:

"failed to update database because the database is read only".

If I stop the execution for 15-20 seconds, then start, it works perfectly, but I don't want to do that.

Can I get some status that the database is created and you can proceed.

Any help would be greatly appreciated.

Dan Rediske · Accepted Answer · 2017-02-09 16:55:20Z

2

It appears that you're connecting to your database and executing T-SQL, you may have to use a query against sys.dm_operation_status and find your Create Database command and whether it has completed. There may be an associated REST API if you choose to program this through REST calls, there is a Get Create or Update Server Status call which might fit your scenario.

You will find that the new database will take some time to create and you won't exit that logic instantly in either approach.

answered Feb 9, 2017 at 16:55

Dan Rediske

8524 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vinit Vishwanathan Over a year ago

Thank u Dan. The Issue got solved when I used the Api.

Dan Rediske Over a year ago

Glad to hear it, hope you find success using SQL Azure

Collectives™ on Stack Overflow

Issue while creating user for a specific database through code in Azure

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related