<div>
<div class="content wysiwyg-content">
Is there an easier way for tracking down the relationships between tables in MS CRM 2011 than using the ER diagram from <a href="http://www.microsoft.com/en-us/download/details.aspx?id=2640?" rel="ugc">http://www.microsoft.com/en-us/download/details.aspx?id=2640?</a><br />
<br />
More particularly, I entered a note for a Contact and I need to build a Select that shows me the note and the Contact’s name.<br />
So I have to go from dbo.Annotation to dbo.Contact.<br />
<br />
I also tried View Dependencies from SQL Management studio but it only shows me BusinessUnitBase and OwnerBase.
</div>
</div>


Is there an easier way for tracking down the relationships between tables in MS CRM 2011 than using the ER diagram from http://www.microsoft.com/en-us/download/details.aspx?id=2640?

More particularly, I entered a note for a Contact and I need to build a Select that shows me the note and the Contact’s name.
So I have to go from dbo.Annotation to dbo.Contact.

I also tried View Dependencies from SQL Management studio but it only shows me BusinessUnitBase and OwnerBase.

DB relationships in Microsoft CRM 2011

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.