Page 1 of 1

MASTER.dbo.sysdatabases

Posted: Thu 04 Jun 2015 08:25
by rept
When I start my application it does:

SELECT SERVERPROPERTY('productversion') AS ProductVersion, SERVERPROPERTY ('productlevel') AS ProductLevel, SERVERPROPERTY ('edition') AS ProductEdition, cmptlevel FROM MASTER.dbo.sysdatabases WHERE NAME = DB_NAME()

But this gives me an error on Azure.

The sysdatabases is deprecated, see also: http://stackoverflow.com/questions/1671 ... n-sql-azur

You use the system view sys.databases which works on Azure.

Re: MASTER.dbo.sysdatabases

Posted: Fri 05 Jun 2015 12:30
by azyk
Please describe the problem you have encountered in more details. If you have a test sample reproducing the issue, please send it to andreyz*devart*com .

Re: MASTER.dbo.sysdatabases

Posted: Fri 05 Jun 2015 14:06
by rept
Hi Azyk,

Sorry, this is a non issue. I found out the sql was from my own application, not SDAC...

Azure works fine thanks!

Re: MASTER.dbo.sysdatabases

Posted: Mon 08 Jun 2015 09:49
by azyk
Glad to see that the issue was resolved. If any other questions come up, please contact us.