I am trying to migrate SQL Server 2017 which is running on on-premise to Google Cloud SQL. I have created the cloud instance & imported my current database backup to it. Now all working fine and able to connect applications to database without any issues except the below one.
Many of the stored procedures in my application is using some custom error messages which was added with the command exec sp_addmessage ...
. But I am not able to run this in Cloud SQL Database since the user don't have sysadmin privilege. When I checked the google cloud documentation for SQL Server it is mentioned as below
For this case there is any workaround(or options) available to run exec sp_addmessage ...
and continue to work all as expected?
UPDATE:
As per the confirmation from GCP Support, currently there is no option to solve this issue by adding custom messages in Cloud SQL Server instance,
but may introduced in future*
. So in my case if I want to proceed with Cloud SQL Server only option is to change the code, otherwise needs to setup andmaintain SQL Server manually with a **Compute Engine** instance
.