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!
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
DB relationships in Microsoft CRM 2011
Posted on 2012-12-31
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.
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.
[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
Active today
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
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
Active 1 day ago
Or you could try this:
http://www.thuta.info/2011/04/xrmvisioer-crmxrm-2011-er-diagram.html
Regards,
Chinmay.
http://www.thuta.info/2011/04/xrmvisioer-crmxrm-2011-er-diagram.html
Regards,
Chinmay.
Featured Post
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.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month7 days, 9 hours left to enroll
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.