Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
larus
Starting Member
17 Posts |
 Posted - 2010-06-11 : 05:53:13
|
| Is there a some kind of ER model for sys catalog views? I would be much easier to query against these system objects if one would know the relationships between the objects. E.g. how to find common column between sys.databases and sys.database_principals??? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-06-11 : 06:16:22
|
| http://www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en |
 |
|
|
larus
Starting Member
17 Posts |
Posted - 2010-06-11 : 07:28:07
|
| Great!!! Many thanks!!! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-06-11 : 09:34:53
|
| I just found out about this today:http://www.quest.com/backstage/promotion.aspxCourtesy of Lee Everest and Brent Ozar:http://www.texastoo.com/post/2010/06/11/Free-SQL-Server-stuff-at-Quest-Software.aspx |
|
|
|
larus
Starting Member
17 Posts |
Posted - 2010-06-12 : 01:45:35
|
| Thanks, great posters! |
|
|
|
|
|
|
ER models for sys catalog views