Dynamics CRM 2011 Database Issue
Posted on 2011-03-01
Recently upgraded from Dynamics 4.0 to 2011. With 4.0, I was able to directly query the database using the contact and account views:
select * from Contact where ContactId = 'XXXX'
However, this no longer works with 2011. It seems I have to specify the actual base and extension tables now, which is a royal pain. For accounts, my queries would need to pull in accountbase, accountextensionbase, and then the relevant address tables. I don't understand why I can't use the account view?
Am I missing something?