SQL: Been told you can't access master database system views in Azure SQL Database? Not true!

added by DotNetKicks
9/17/2019 5:26:37 PM


When you work with Azure SQL Database, you'll quickly learn that you send queries to a single database, and you can't execute USE statements to change to another database. Importantly, you also can't use four-part names to access objects in other databases like this: ServerName.DatabaseName.SchemaName.ObjectName So it's not surprising that when I've been reading some ...