All tags
3D 61850 64 bits 7u51 AA Active Directory ActiveX Addon Adeunis ADO ADODB AE Alarm Alarm sythesis Alarm viewer Alarming Alarms Alert Animations ANSI Anywhere USB Applet Application Architect Application Explorer Applicom Architect Archive Archives Archiving ASCII Audit Autosize Average AVI BACnet Big data Bottleneck Broadcast Byte CFR21 Chart Control CHRONO Cimway Client Code Page Codec Comm.dat Command line Commend Communication Compatibility Configuration environment Copyfield Cosmos DB Cron CSV Cyclic DALI Dashboard Data acquisition Data Export Database DataVue DCOM DDE DDE Server Debug Demo Demo project DEP Diagnostic DirectLink DNP3 Documentation Domain Domain controller Dongle Drawing Dream Report DVD extras EDE Email Enable Equipment Error Error ID Error messages numbers ESXi Ethernet Ethernet direct Ethway Event viewer Events Excel Export Expression FAQ File Fipway Firewall Font Form FrontVue General GEZE Gmail Graphics Grid Groupalarm Handled Handles Hardcopy HDS Historic HMI HP Icx IEC IEC 61850 IIS Iks Import Installation Internet Internet Explorer Intravue IoT IP Izot Java JRE JSON Kerlink Key Keyboard KNX Language Libraries Library Licence Utility License License Utility Licensing LNS Log Log files Log viewer LogList Logoff LogViewer Lonworks LoRaWAN Memory Memory leak Messages Migration Mimic Modbus TCP/IP Modem Molex Moxa MQTT MSSqlServer Multimedia Multiregion Multistation Multitech MXview MySQL NetBIOS Network Network analyser Networking News NL220 Obsolete articles ODBC Offline OPC OPC-DA Client OPC-DA Server Open Weather Map Operating System Password PcVue PcVue 10 PcVue 12 PcVue as a service PcVue features PDF Performance PlantVue PLC Print Private Process Profibus Project management Protect Tools Protocol Provider Proxy Pulse Quickstart Recipe Region Regular Release info Replication Rest RLM RTE Ecowatt Russian S7 S7 Fetch/Write S7 ISO SAIA Sample project Scada Basic Schedule Scheduler Scripting Security Segmentation Sentinel Setup SG Siemens Sigfox Silent installation Simulation Single line diagram Smart Generator SMS SnapVue SNMP Solar SQL SQL Server SQL Server 2014 Start Startup String Substation Automation Summer SV Manager Toolkit Svmgr SW1000 Switch Syslog System Text TFTP Threads Time Timeout Timer Timestamp Toolkit Tools Touchscreen TouchVue Trace Treatments Trend Trend viewer Trends Troubleshooting Unitelway Upgrade Useful tools Username Varconf.dat Varexp Variables VBA Version control Versions Virtual machine Virtualization VmWare VPN W7x64 WAGO Watchdog Web Web Services Web Services Toolkit Web.configsvmobile WebScheduler Webvue Windows domain Windows Terminal Server Windows update Winter Workaround Workspace Write Commands
System

[KB1042] Simple query to count record in SQL Server grouped by variable name

Applies to: PcVue 8.10 onwards Summary: A good practice for SQL Server database size optimization is to investigate which tags are recorded more often than others. This allows for example […]

98
System

[KB839] Using Transparent Database Encryption (TDE) on an SQL Server database

Applies to: All versions of PcVue that support the HDS Summary: This article explains how to enable and disable Transparent Database Encryption (TDE) on an SQL Server database. TDE is […]

177
System

[KB809] Setup of SQL Server 2014 fails

Applies to: SQL Server 2014 Summary: If the installation of SQL Server 2014 fails close to the end. Details: If the installation of SQL Server 2014 fails close to the […]

85
System

[KB761] Useful SQL Scripts

Applies to: All versions of PcVue Summary: Some example SQL scripts useful for troubleshooting.Originator: NK Details: GetDBSize.sql Script providing information about the space used by the data vs the space […]

278
System

[KB722] PcVue VS SQL Server Compatibility

Applies to: PcVue 8.10 and later Summary: List of SQL Server version and PcVue version with which it has been qualified. Qualified means it has been tested and verified and […]

379
System

[KB634] Error message Attempt to initialize the CRT more than once while launching PcVue

Applies to:PcVue version 8.10 onwards. Symptom:The following Windows error message is prompted at PcVue startup and PcVue can never be launched. “Attempt to initialize the CRT more than once” Details:A […]

86
System

[KB585] How to change database collation

Applies to: SQL Server. Summary: This article explains how to modify collation to avoid conflict between two databases. If collation is not the same on the two replicated databases, replication […]

236
System

[KB555] Backing up SQL Server databases with HDS storage units

Applies to: PcVue version 8.10 onwards Summary: This article guides you through setting up a backup strategy for HDS databases. The actions shown were taken with a version of SQL […]

538
System

[KB521] SQL Server Express Limitations

Applies to: SQL Express 2005 and 2008 Summary: This article is a reminder of the SQL Express database size limitations Details: Version Database size (.mdf) SQL Express 2005 4 Gb […]

197
System

[KB492] How to display local time in an SQL Server view

  Applies to: Pcvue all versions Summary: This article explains how to add a TIMESTAMP field dynamically to Read requests from an external tool (for example SQL Server Management Studio) […]

757
System

[KB487] How to reduce the database LOG file (.ldf) size

Applies to: PcVue all versions. Summary: This article will help you to reduce disk space used by your LOG file when using the HDS and SQL Server 2005 or later. […]

387
System

[KB481] HDS stopped

Applies to: PcVue version 8.2 onwards. Symptom: An historical configuration based on HDS is configured but the HDS never starts. Details: This issue may appear if you installed SQL server […]

339
System

[KB474] Integrity error DBCC CHECKDB

Applies to: SQL Server 2005 onwards. Summary: This article explains how to manage an consistency / integrity / DBCC CHECKDB error. Details: A data base may become corrupt. In this […]

91
System

[KB462] How to change SQL server password

Applies to: PcVue version 8.10 onwards. Summary: What to do if you forget the password needed for SQL to connect its SQL Server process? Details: All is not lost, you […]

106
System

[KB428] How to connect to a SQL Server instance

Applies to: PcVue all versions. Summary: This article is a reminder about how to connect to an SQL server 2008 R2 instance. Details: Here are the correct formats to connect […]

197
System

[KB328] SQL Server Firewall

Applies to: SQL Server 2005 This article contains obsolete references. Summary: By default ports and used protocols are: SQL Server uses the port 1433 ( TCP) SQL Browser uses the […]

135
System

[KB327] Enable the SQL Server Browser service

Applies to: SQL Server 2005 Summary: To facilitate the configuration of the posts, the SQL Server browser allows the discovery on the network of the SQL Server and the offer […]

107
System

[KB325] What do the EventNumber, VarType and AlarmState columns mean ?

Applies to: PcVue all versions. Summary: The meaning of the EventNumber, VarType and AlarmState columns in an SQL database as used by the Historic Data Server (HDS). Details: Sometimes it […]

286
System

[KB314] SVSQL mode CONNECT – Return Code: 0

Applies to: PcVue all versions. Summary: The SCADA Basic instruction, SVSQL mode CONNECT, return code 0 is not documented in the online help. The online help describes the verb “CONNECT […]

218
System

[KB312] SQL Server 2008 Unnamed Instance

Applies to:SQL Server 2008. Summary:It is not possible to create a database with SQL server 2008, installed as unnamed instance, when using generic syntax “.\”. This syntax, which allows access […]

38
System

[KB311] Sql Server 2005 Express installation problem with MSXML SP2 on XP

Applies to: SQL Server 2005 and Windows XP Summary: SqlServer setup fails: SqlServer setup does not complain about missing prerequisites but is unable to install MSXML extensions and the MS […]

36
System

[KB305] Replication sample with 2 SQL Express and 1 SQL Standard

Applies to: PcVue all versions with support for SQL Server 2005.The basic content of this article may also be applicable to other versions of Pcvue and SQL Server although the […]

220