ActiveXperts Knowledge Base Article 6600130

Q6600130 - I want to execute a SQL query to modify data in the CONFIG.SDF configuration database file using a sql script. Is this possible?

Yes, it is possible. The database is a Microsoft SQL Server Compact Edition file, and can be opened in Microsoft SQL Server Management Studio (part of Microsoft SQL Server):

• Launch SQL Server Management Studio;
• In the 'Object Explorer' window, select the 'Connect...' drop down box, and select 'SQL Server Compact...';
• Specify the 'Database file' and click 'Connect'.

You can now execute your database queries.

Please note that all checks are stored in the 'Nodes' table. The 'Nodes' table contains all folders and checks data.

---

If you cannot find an answer to your question(s) in our Knowledge Base, or if you need additional information or assistance, please contact our Customer Support using our Contact Support Form