Mime-Version: |
1.0 |
Content-Type: |
text/plain; charset="UTF-8" |
Date: |
Thu, 17 Aug 2017 10:50:38 -0400 |
Reply-To: |
|
Subject: |
|
Content-Transfer-Encoding: |
quoted-printable |
Message-ID: |
|
Sender: |
|
From: |
|
Parts/Attachments: |
|
|
Hello all,
We have some object numbers entered wrongly by an intern who confused 1 with I for about a hundred entries. I would like to just edit it directly in SQL Server using the Object Number column. However, I do see that there are other columns that use run off the Object Number. For example, SortNumber is an edited version of ObjectNumber, as is SearchObjectNumber.
Would it be a terrible idea to edit these three fields in SQL Server directly, or are there are caveats and other places that use ObjectNumber and it would cause a distressful mess?
Is there anything anyone does specially?
TMS does have a "change object number" option but that is per object/ entry and would take us ages to do one by one.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
|
|
|