Reference to database and/or server name in 'master.sys.databases' is not supported in this version of SQL Server.

by ebarcza 6/19/2020 8:08:00 AM

You use the system view sys.databases (without the master qualification, it is not needed)

The system table sysdatabases has been deprecated since SQL Server 2005 (Azure is a later version) and in any case is not supported on Azureer 2005 (Azure is a later version) and in any case is not supported on Azure

8e359391-0a94-4a94-8390-c6cb12bdfa57|1|1.0

Tags: azure sys.databases

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen

About the author

Name of author

Author name
Something about me and what I do.

E-mail me Send mail

Send mail

Calendar

View posts in large calendar

Pages

Recent posts

VSTS new branch not visibleRating: 0 / 0
SSRS RDL phone number formatRating: 0 / 0
Reference to database and/or server name in 'master.sys.databases' is not supported in this version of SQL Server.Rating: 1 / 1
How To Rename a database in SQL AzureRating: 0 / 0
How to solve “The specified service has been marked for deletion” errorRating: 0 / 0
Where is the Spotify QueueRating: 0 / 0
Installing a Windows Service with PowershellRating: 0 / 0
Visual Studio 2017 setup project missingRating: 0 / 0
Creating a new User in Azure SQLRating: 0 / 0
What is a CNAMERating: 0 / 0

Recent comments

ReportViewer Control: Fit to Page (1)
Agustina Sappah wrote: Hi. I just noticed that your blog looks like it ha… [More]
XP Restart over Remote Desktop (1)
aperitivo roma wrote: I love this blog [More]
Why WebMethods cannot be static methods (1)
games wrote: Wii users will be able to download a selection of … [More]
Sys.Webforms.PageRequestManagerServerErrorException (1)
Photo to Painting wrote: Great Work Regards Rolonirst [More]
Multiple Controls for One modalPopup (1)
ebarcza wrote: huh? [More]
Canceling Application.Ontime in excel (1)
ebarcza wrote: test comment [More]
DataFormatString CSharp ASP.NET (1)
Rich wrote: GREAT POST! Is really helpful for a quick referenc… [More]
Firing Update Panel From A GridView Button (1)
kral oyun wrote: Thank you very good article [More]
Changing datasource in rdlc, VB.NET (1)
Erik wrote: Great post, thanks for the help [More]
First Blog Entry (1)
Admin wrote: comment [More]

Authors

Tags

Blogroll

Download OPML file OPML

OPML

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2021

Sign in