Microsoft Dynamics CRM

Home » Microsoft Dynamics CRM » Microsoft Dynamics CRM Forum » All Tags » SQL 2005

Browse by Tags

Tags
Related Posts

  • Forum Post: Re: Re: Re: Re: Re: Re: Re: View accounts like hierarchy / treeview

    Andrew Zimmer
    Awesome post guys! Really good stuff. Here is a query you can give a try. Hope this helps: with RecursionCTE (parentaccountid, accountid, [name]) as ( select R2.parentaccountid, R2.accountid, R2.name from filteredaccount as R2 where r2.accountid = 'D0E4DC4D-1C09-DE11-A512-0003FF800564'...
    on 4 Mar 2009

  • Forum Post: Replicating CRM database for reporting services

    Afro Boy
    Hi folks, I'm trying to set up a replicated copy of the x_MSCRM database to use for our Reporting Services. The issue is that some of the views reference tables that don't exist. Don't know how that works though. Also, many of the User Defined Functions have similar dependencies. Whilst creating...
    on 1 May 2009

  • Forum Post: Re: Re: CRM 4.0 Report Name Expressed as the Report Entity Record's GUID

    Dodd
    I have not seen any documentation on this issue, nor have I heard of a workaround or a proposed fix, but the more my clients request new reports, the more complaints I receive, and I have no way of answering them.
    on 12 Aug 2009

  • Forum Post: Error Syncing Records

    Ravi Ragoonanan
    Hey Guys, When we try to Track In CRM via the Outlook Client, we get the following error. "A SQL Server Error Occured. Try this action again." We are unable to get to what could be causing this error. We are running MS Dynamics CRM 4.0 SQL Server 2005 SP2 Outlook Client for MS...
    on 28 Sep 2009

  • Forum Post: Problems with reports in CRM 3.0

    Miguel Angel Alvarez
    Reports works from the server, but not from all other domain computers. We can see the reports list, but we can not access them. We have the same problem using IE and the Outlook client. We can access without problems all other CRM functionality within all domain computers; reports are the only thing...
    on 10 Nov 2009

  • Forum Post: Re: Re: SQL query - exclude deleted records?

    xZara
    Thanks for the quick reply - I ran the query again but from FilteredAppointment but strangely the records are still showing up so I ran the query from Appointment and included the field DeletionStateCode and its showing up as 0 for the records that should be showing up as deleted. Any ideas? Thanks...
    on 1 Apr 2010

  • Forum Post: SQL query - exclude deleted records?

    xZara
    I am new to microsoft crm and I created a query in SQL (that I will use to link to an external database for a report) but deleted records are showing up, at least the records are not visible in CRM but are in the SQL tables - how do I exclude these records? I am querying appointments. Thanks for your...
    on 1 Apr 2010

  • Forum Post: CRM FilteredCustomerAddress

    Niraj Patel
    Can anyone tell me why my filteredcustomeraddress view has 65000 entries (I have 9000 accounts and 23000 contact) and when I run the below SQL query I get usedSpaceMB of 1284. Thats 1.2GB on addresses. The total size of my CRM DB is reaching 7GB. SELECT object_name(i.object_id) as objectName, i.[name...
    on 15 Jun 2010