Deletion of Fields - MS reps out there?

Haven't seen this asked in a while... any chance of field deletion in the
future? We have about 20 extra fields we do not use/need.

Kristina

ps
We have a test environment, I would be happy to give things a try if anyone
has done this already...

Matt
Sun Aug 22 22:31:59 CDT 2004

Kristina,

There is a way to do this.

First, make sure the field isn't being used in any forms, views or maps. This
needs to be done manually. Though there are tables you can query to determine
some of this information.

Then, use the sp_ReplDropColumn command to remove the field. This will ensure
that replication "sees" the change. The thing I haven't tried yet is to see if
this will actually trickle down to a SFO machine properly or not.

Then, remove the field from the Attributes table in the Metabase.

Finally, publish.

This should clear everything up.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Fri, 20 Aug 2004 10:02:21 -0500, "Kristina Ledford" <noemails@noemails.com>
wrote:

Haven't seen this asked in a while... any chance of field deletion in the
future? We have about 20 extra fields we do not use/need.

Kristina

ps
We have a test environment, I would be happy to give things a try if anyone
has done this already...

Matt
Sun Aug 22 22:32:32 CDT 2004

PS: I forgot my std qualifier: MAKE SURE YOU HAVE BACKUPS. :-)

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Fri, 20 Aug 2004 10:02:21 -0500, "Kristina Ledford" <noemails@noemails.com>
wrote:

Haven't seen this asked in a while... any chance of field deletion in the
future? We have about 20 extra fields we do not use/need.

Kristina

ps
We have a test environment, I would be happy to give things a try if anyone
has done this already...