Auto-Populating Field in CRM

I have added a field to the Accounts table for capturing the Moody's Credit
Rating. Currently, we have this information stored in a different system. I
would like to do a nightly refresh of the information from our external
system directly into CRM via SQL Server.

Are there any issues I need to consider writing a script to perform this
action. Keep in mind that I will only be updating a CUSTOM field on the
addressbase table. Specifically, I am wondering if there are any triggers on
the table that might cause issues if I update these items. I would like to
do this directly through the database (which I realize is not technically
supported, but we are talking about a custom field here), and not need to
resort to the much slower SDK route.

Thank you,
Paul McBride

John
Wed Feb 09 22:38:52 CST 2005

you should be okay. How many are you expecting to update?

--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us


"Paul McBride" <pmcbride@comcast.net> wrote in message
news:uAAIyhrCFHA.3928@TK2MSFTNGP15.phx.gbl...
> I have added a field to the Accounts table for capturing the Moody's
Credit
> Rating. Currently, we have this information stored in a different system.
I
> would like to do a nightly refresh of the information from our external
> system directly into CRM via SQL Server.
>
> Are there any issues I need to consider writing a script to perform this
> action. Keep in mind that I will only be updating a CUSTOM field on the
> addressbase table. Specifically, I am wondering if there are any triggers
on
> the table that might cause issues if I update these items. I would like to
> do this directly through the database (which I realize is not technically
> supported, but we are talking about a custom field here), and not need to
> resort to the much slower SDK route.
>
> Thank you,
> Paul McBride
>
>