{}

Vores varemærker

Impact-Company-Logo-English Black-01-177x54

Velkommen til Schneider Electrics website

Velkommen til vores website
Hvordan kan vi hjælpe dig i dag?
How to correct the spelling of the Measurement StandardName in EEM through SQL Database Edits
Issue
User has a spelling mistake in a measurement name and wants to correct the name beyond just updating the display name.

Product
ION EEM 3.95 Sp1, 4.0, 4.0R2, 5.0

Environment
SQL Server Management Studio (SSMS)

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

1) Open SSMS and connect to the EEM database
2) Expand Databases --> ION_EEMData -->Tables
3) Right click on dbo.TS_Resources and select "Edit top 200 rows"
4) Click the "Show SQL Pane" Icon and add the filter "Where Name like '[name of incorrect measurement]' " (without double quotes)
5) Click execute
6) Modify the name to the correct spelling
7) Click on a new line to commit the changes
8) Repeat steps 3 through 7 on tables dbo.RPT_Measurement and dbo.MM_MeasurementMap updating DisplayName, FullName and StandardName

Schneider Electric Danmark

Se mere
Område:
Artikler som kan være nyttige
Se mere
Område: