Solved

DB relationships in Microsoft CRM 2011

Posted on 2012-12-31
2
1,617 Views
Last Modified: 2013-01-12
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.
0
Comment
Question by:mihaisz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 51

Assisted Solution

by:Mark Wills
Mark Wills earned 250 total points
ID: 38734378
Yeah, it is a pain in the proverbial but "they" all say use those ER diagrams.

It has been quite some time since playing with CRM at a DB level, but thought I would chime in anyway...

There is a bit more help out there...

Have a look at the reporting modules and the "Filtered" views (filtered taking into consideration the permissions you have to actually see the data) : http://msdn.microsoft.com/en-us/library/cc308184.aspx And following that through... I have linked to the "customer" filtered views : http://msdn.microsoft.com/en-us/library/dd548500.aspx

Look for "Report Writing" as a general guide - found more help that way than trying to unravel the actual database. Having said that, once you get into the actual DB and have a look at the views (the views also exist without the "filtered" prefix)

http://msdn.microsoft.com/en-us/library/cc308174.aspx

Hope that helps a bit...

p.s. there is a wiki which might help : http://social.technet.microsoft.com/wiki/contents/articles/2490.microsoft-dynamics-crm-2011-development-resources-en-us.aspx
0
 
LVL 27

Accepted Solution

by:
Chinmay Patel earned 250 total points
ID: 38738318
0

Featured Post

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question