Pages

Search

Microsoft CRM - CRM Database Schema

Microsoft CRM - CRM Database Schema

CRM Database Schema

Posted: 04 Jun 2004 08:05 AM PDT

Matt,

Thanks.

I can see the main links when I put them into EM but I need a higher level
overview and field explaination. Some are obvious but others are not, at
least to me. One thing in particular I am trying to figure out is just where
things are kept. For example, where is the "body" of an activity?

Thanks,

Walter


"Matt Parks" <com> wrote in message
news:com... 
between 
Microsoft 

HOWTO: Customizing CRM - include auto-number field?

Posted: 03 Jun 2004 08:49 PM PDT

Watch out for deadlock and transactional issues around this though. Don't
follow the original MSDN callout documentation that shows a call directly
back into the platform during the callout - use the more recent MSMQ-based
version. You'll have yourself a lot of hassle in the long run.

"John O'Donnell" <com-nospam> wrote in
message news:phx.gbl... 

MSCRM time out?

Posted: 03 Jun 2004 08:11 PM PDT

Using this type of access would be a violation of the EULA for MS CRM. Legally,
the licensing is tied to a person, not an AD login.

As for the timeout, since the app uses integrated security and does not use the
session, there is no timeout functionality.

Matt Parks

----------------------------------------
----------------------------------------
On Thu, 3 Jun 2004 23:43:08 -0700, "Mark" <microsoft.com>
wrote:

Thanks, but I think you're referring to adding a user to
the system, I was asking if I had 2 people who use the
same login to the domain and same login to the CRM system
and who access the system at the same time, will one of
them receiver an error message?

Btw, you have any idea bout the time-out functionality if
its supported? ThanksAgain
 
directory. This means 
your first user, 
a second user. You 
licenses among users. 
message 
to 

Reports list view isn't displayed

Posted: 03 Jun 2004 03:37 PM PDT

No for both. Report list view mentioned here are from
sample database. there is no customized report involved.
Looks like not pure user privileage issue, since login as
administrator(domain) results in the same error.

Thanks for your response.
 
Knowledge Sync installed? 
message news:17ea201c449bb$5c1d69c0$gbl... 

Unexpected Errors sending email

Posted: 03 Jun 2004 02:21 PM PDT

Mark,

Check the registry on the CRM server. Under the local
machine\software\microsoft\mscrm key there will be an entry for the Exchange
server. Verify that the URL appears valid. Also, check to see if you have SSL
installed on the Exchange server for OWA.

Matt Parks

----------------------------------------
----------------------------------------
On Thu, 3 Jun 2004 14:21:56 -0700, "Mark DiMartino" <com>
wrote:

I have just installed CRM.

I am having problems sending email from it.

When I set the DevError on the config file to on it
states:

An unexpected error occured. An error occured attempting
to dispatchthe email: HTTP Status: 404 Nor Found. URL may
be invalid. Error Number 0x80040216.

Source d:\crm\build\3297
\src\platform\include\proxy\proxyutil.h

Line 47

Query String //Activities/Email/edit.aspx

Can anyone shed any insight on this?

Thanks in advance.

CRM Usage - Question

Posted: 03 Jun 2004 12:36 PM PDT

just to clarify. If you use outlook crm client you can only view reports
while online. Once you are offline etc you cannot view reports.
"Per Geert |Nielsen" <microsoft.com> wrote in message
news:17f0501c449ca$420a4fd0$gbl... 

Question: deleted user in active directory before deleting in crm

Posted: 03 Jun 2004 10:36 AM PDT

Hi,

In what tables there is need for delete depends on how
much the user has worked with the system. Therefore look
through what data you don't want to lose. For instance
the user might be an account owner etc.

If you try to delete the user (in the SystemUser table)
it starts telling you what table will be inflicted. You
go to this table and try to delete that record/s. And so
on until you are allowed to delete the user. It's risky,
but so is life...

I know, I know last time I wrote about this I got
complaints. Microsoft will not support this blah blah
blah. But if there is someone who can tell me an easier
way out of this you're more than welcome.

Monika
 
please tell us what 
message 
back 

Global Replace

Posted: 03 Jun 2004 09:30 AM PDT

Yes, you would just issue a command like

update LeadBase
set CFPfield1 = NULL
where CFPfield1 = 2

This is assuming the underlying value for "no interest" is 2.

Matt Parks

----------------------------------------
----------------------------------------
On 3 Jun 2004 22:58:46 -0700, com (Lee) wrote:

Unfortunatly I'm no SQL expert. Can you tell me if it is possible to
issue a command like, for example, if custom field 1 is populated with
no interest (from the pick list) then clear the contents of this
field?

If the above isn't possible I assume it would be possible to clear the
contents of custom field 1 for all lead records using a SQL command?

Thanks
Lee
Matt Parks <com> wrote in message
news:<com>... 

Access to Web Client

Posted: 03 Jun 2004 07:49 AM PDT

Gary,

You missed the other option and that is to allow access to CRM w/o SSL. Depends
on whether or not they want the security that SSL provides.

Matt Parks

----------------------------------------
----------------------------------------
On Thu, 3 Jun 2004 16:07:55 -0700, "Gary" <NOSPAM.com> wrote:

Uhmm.........you weren't very clear. I'll assume you want to connect to your
CRM server from the outside? Well there are two ways of doing this. One,
make your IIS accessible to the public via SSL. And two, use VPN.

I've never done the SSL route, but VPN works just fine for us. The way this
works is that the remote client first connects to the internet, then does a
VPN to your network. Then he can access crm via IE just like as if hes in
the office.

As for the SSL way, check out the IG, I believe its explained in
there,.......

-Gary

"Ian" <microsoft.com> wrote in message
news:17bb901c4497a$0344ba10$gbl... 

Can teams OWN objects?

Posted: 03 Jun 2004 12:01 AM PDT

No,

object are only own by employee, users or group. However you can share
information within team (that their purpose)

Antoine


"RF" <microsoft.com> wrote in message news:<179df01c44938$99ac0400$gbl>... 

Installation of CRM Server result in Unknown Error 80040E31

Posted: 02 Jun 2004 11:56 PM PDT

If the server that is running Microsoft CRM co-exist on
the same server as Microsoft SQL Server performance is
likely to be degraded because of "resource competition"
and this could result in the time out.

So if this is the case you might want to install Microsoft
CRM on another server.
 
server on windows 2003 and database server is SQL 2000 SP3
on windows 2003. A new domain was created on a single
server. Installation goes fine for a long amount of time
then at the very end I get the following error.... I have
uninstalled and reinstalled 4 times!!! Please help! 
files from the SQL 2000 server and have also 
but I am running the SQL2000 and the CRM on a same machine
on its own domain. Why would there be a timeout? 

CRM SFO Client: .ost or .pst?

Posted: 02 Jun 2004 05:41 PM PDT

As tony mentioned .ost is the offline folder. As for the interaction between
CRM-SFO and the pst/ost folders, well.........there is none. You just need
the exchange profile (don't think you can even install it without this). The
pst/ost folders are of mere preference in wether you want to archive or
maintain offline retrieval.

-Gary
"Dave Carr" <microsoft.com> wrote in message
news:1722701c44903$93a414b0$gbl... 

new crm reports

Posted: 02 Jun 2004 12:25 PM PDT

I installed the enhancemensts off of the cd for crm and I
installed 9.2.2.634 Pro from the crystal cd. The path I
took to get to the reports is:
C:\program files\microsoft crm\crystal
decisions\enterprise 9\FileStore\Input
I opened one of the folders until I got to the report, I
made some changes, and saved it to this folder.

Crystal isn't registered since this is my test environment
and I don't have access to a printer or the internet. I'm
not sure if there is a problem using Pro9 to create the
report and saving it in enterprise9 directory. I also
tried creating a report from scratch and saved it at the
root of input. The report works when I run it from within
crystal, I just can't figure out how to get that report to
be an option in crm under the report section.

Thanks for all of your help,
Jen
 
integrating your customized reports. Take a look to the
White paper for Reports on Microsoft web site 

IE and bandwidth use

Posted: 02 Jun 2004 09:27 AM PDT

Thanks Gary, that was great info

 
8&c2coff=1&safe=off&threadm=eJJwpM2IEHA.940%
40tk2msftngp13.phx.gbl&rnum=1&prev=/groups%3Fhl%3Den%26lr%
3D%26ie%3DUTF-8%26safe%3Doff%26c2coff%3D1%26q%3Dbandwidth%
26btnG%3DSearch%26meta%3Dgroup%253Dmicrosoft.publi c.crm 

SQL server eval copy has expired on new CRM demo

Posted: 02 Jun 2004 07:48 AM PDT

MS KB says move DBs, uninstall SQL, and reinstall.
That would be insane amount of trauma.

I rolled back the date on the box a month, and SQL quieted down.
VPC picks its date up from the host box. My VPC is on a test box, so who
cares what date it is....
Not sure if this will work, but so far, so good.

-Bill

"Edwin Garst" <epconsystems.com> wrote in message
news:%phx.gbl... 
the 
step