Hi All, I was importing database from one database server to another in cloud, but after importing 30 databases it gives an error that, " Database creation would exceed quota of 30 The transaction ended in the trigger. The batch has been aborted. (Microsoft sql server error: 50000)"
Plz let me know is there any setting or way where i can increase the limit of no of databases. Or is there any other solution.
Depends what yoou are usoing - it will be a limitation on that server which could be host specific. Azure has a default of 150 (or 149).
You might consider reducing the number of databases maybe using schemas instead. Also need to look at all the limitations on that server to see if anything might impact you - like max size of a database or total storage.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.