SQLServerPedia Wiki

March Madness – SQL Azure – sys.databases

Yesterday we talked about the user information you can get from SQL Azure. Today we are going to focus on the details you can gather about the databases for your SQL Azure instance. You can run the following code to view details about the databases for your SQL Azure server instance:

SELECT *
FROM sys.databases

What is this system view [...]

March Madness – SQL Azure – sys.sysusers

March Madness – SQL Azure – sys.sysusers

Yesterday we started this blog post series with a look at the sys.sql_logins system view in SQL Azure. Today we will look inside the user information found in the sys.sysusers table.
Unlike the sys.sql_logins view which is found only in the master database, the sys.sysusers view is in each database. After connecting to your SQL Azure instance you [...]