Q6600130: I want to modify 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 run your database queries.
Please note that all checks are stored in the 'Nodes' table. The 'Nodes' table contains folders and checks only.(viewed: 275)