MASTER.dbo.sysdatabases
Posted: 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.
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.