
Hi Team,
I am getting an error below while i am trying to run sql server Procedure in MS Flow
Error:- Reference to database and/or server name in 'master.dbo.sysdatabases' is not supported in this version of SQL Server.
Please help in solving the problem
Thanks
Lohit
Hi Lohit,
Does this action work for you before? Is this the first time you got this error?
What’s the version of your SQL Server?
Are you able to use other actions for SQL Server?
I have seen similar error on these two threads, please check them for a reference:
https://stackoverflow.com/questions/16710783/sql-azure-how-can-i-select-sysdatabases-table-from-master-database-in-sql-azur
https://social.msdn.microsoft.com/Forums/en-US/fefd38dc-d7ae-4b8d-8b47-839d7f6b6d04/reference-to-database-andor-server-name-in-mastersysdatabases-is-not-supported-in-this-version?forum=ssdsgetstarted
Best regards,
Mabel Mao