THis is undocumented SP in SQL Server still carried over to SQL 2005.
I use [?] to include all databases that include a space between Words etc.
''?'' to include the name of the Database in the select list to easily identify, what users belong to which DB.
sp_msforeachdb @command1='use [?] select ''?'' as dbname, name from sysusers order by name'
To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the metadata functions. They save a great deal of time and typing when querying the metadata. Once you get the hang of these functions, the system catalog suddenly seems simple to use, as Robert Sheldon demonstrates in this article.
2016-03-28
6,652 reads
To finish this short series on extended properties a look at documenting sets of database objects
2011-04-05
8,568 reads
Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties
2011-03-29
11,730 reads
In this second article of a short series we look at using the Extended Properties which you have added to a database
2011-03-22
11,826 reads
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
22,472 reads
