ActiveXperts Knowledge Base Article 6600130

Our mission at ActiveXperts Software is to deliver high quality Network Monitoring solutions and Windows Development components. Our goal is to supplement these solutions with timely support resources that can help at many different levels.
The first thing you want to do is try to find the answer to your problem in the Knowledge Base. If you cannot find an answer to your question in our Knowledge Base, or if you need additional information or assistance, please use our Contact Support form.

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