When a new database is created database_service_objectives table isn't updated with the new row for that DB

Hi @ KALAHASTI N MaheshKumar

Thanks for the question and using MS Q&A platform.

As per my understanding, your database_service_objectives table isn't creating a new row with the latest database_id and there are no issues with the tables.

Here are some possible reasons:

database_id in sys.databases and sys.database_service_objectives represents a global identifier that is unique within the logical server.

DB_ID may only be used to return the database identifier of the current database in Azure SQL Database. NULL is returned if the specified database name is other than the current database.

If the caller of DB_ID does not own a specific non-master or non-tempdb database, ALTER ANY DATABASE or VIEW ANY DATABASE server-level permissions at minimum are required to see the corresponding DB_ID row. For the master database, DB_ID needs CREATE DATABASE permission at minimum. The database to which the caller connects will always appear in sys.databases.

For more information, please refer to these Documentations:

https://zcusa.951200.xyz/en-us/sql/t-sql/functions/db-id-transact-sql?view=azuresqldb-current#remarks
https://zcusa.951200.xyz/en-us/sql/relational-databases/system-catalog-views/sys-database-service-objectives-azure-sql-database?view=azuresqldb-current

I hope, This response will address your query and helped you to overcome on your challenges.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Hi @KALAHASTI N MaheshKumar

I attempted to reproduce the scenario, and if your goal is to update the database ID for your database, you can try the following steps:

1. I had a database A with a database ID of 6.
2. I deleted database A.
3. I created a test database named Test.
4. Now I recreated Database A, and it was assigned a new database ID.
5. Deleted Test database.

If you want to assign a new database ID to your database, you can follow the steps above. However, I strongly recommend testing this process first in your pre-production environment to ensure it meets your requirements.

Thank You!