The SQL Statements I've written are intended to empty those entities. If you want to delete specific entity items you can't delete, use something like: DELETE FROM opportunityBase WHERE opportunityid...

Sure. In the advanced find window add a new condition "status equals published" and you will only see the published articles. -- Michael Höhne, Microsoft Dynamics CRM MVP Web:...

Hi Kathleen, As of now we have not incorporated the invoice functionality in our component but I guess it will not be a rocket science to do it, since we are already capturing billable time and...

Boolean1 wrote: I encountered this error as well. Our CRM and SQL machines were behind in patches, so I applied all Windows updates to the CRM machine and SQL-specific patches to the SQL machine. ...

Hi, I was wondering how to modify the default 1:N relation to 1:1, between opportunity and quote. I suppose that could be managed modifing the CRM WorkFlow? However I actually don't know how. Thanks...

Can anyone advise us on how to do an advanced search for all Contacts belonging to any Account from a particular Industry sector? I can easily generate a list of all accounts that are marked as...

had a look under there and did not see any reference to an IP. just the URL for the CRMWEB... Server Name which is right,etc. i am just puzzled as to why this changed? i've never modified the host...

are you talking about the report writer that is part of sql 2005? ============================== John O'Donnell Microsoft CRM MVP http://www.crowecrm.com "Matt" <Matt@discussions.microsoft.com>...

If workflow cannot do something you need you can always write a .Net assembly that workflow can call. ============================== John O'Donnell Microsoft CRM MVP http://www.crowecrm.com "beam"...

I don't believe that you can copy and paste HTML code into the web interface and expect to see it show up on the other side, may be you can open the HTML with word and try to copy and paste it that...

I have used the workflow API before to attach certain entity to workflow, remove then from workflow. Darren Liu Crowe Chizek and Company http://www.crowecrm.com Arashs wrote:

Isn't the last modified by reflects who shares the record? But this is a good suggestion. If different user changes the record after the integration. then you don't know who the default user shares...

AMAIZING!!! Thanks, great call. Kyle

Hello, because of the nature of web applications, there is no way to truely tell who is still logged in. Users can simply close their browser or navigate to another site. CRM doesn't ship with any...

Hello, 1) When looking in a queue, you can hold down the CTRL button and click multiple items, then delete them all at once. 2) When you delete them, CRM actually just updates a flag in the...

Hi John I know its been a few months since you were addressing this issue, but we have the same problem and i was wondering if this was ever resolved for you?? Cheers Tracey "John" wrote:

Hi, When you go into the security role screen, as you click the little circle for the delete privelege for a Contact for example, ...as you keep clicking theh circle, it cycles through different...

How about: Create a new numeric attribute (e.g. TabATotal) for the account and add it to the account form. Use client script on the OnChange event for each question field to add up the number of...

There is no way of changing the relationships between the system entities (e.g. lead, contact, opportunity), so I doubt any 3rd party can help. What you're better off doing is treating the existing...

Try running the User Summary report. The layout is biased towards seeing what roles each user has, rather than vice versa, but it should still be helpful "elphi" <elphi@discussions.microsoft.com>...