MASTER.dbo.sysdatabases

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
rept
Posts: 20
Joined: Mon 30 Oct 2006 09:15
Location: Belgium

MASTER.dbo.sysdatabases

Post by rept » Thu 04 Jun 2015 08:25

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.

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: MASTER.dbo.sysdatabases

Post by azyk » Fri 05 Jun 2015 12:30

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 .

rept
Posts: 20
Joined: Mon 30 Oct 2006 09:15
Location: Belgium

Re: MASTER.dbo.sysdatabases

Post by rept » Fri 05 Jun 2015 14:06

Hi Azyk,

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

Azure works fine thanks!

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: MASTER.dbo.sysdatabases

Post by azyk » Mon 08 Jun 2015 09:49

Glad to see that the issue was resolved. If any other questions come up, please contact us.

Post Reply