Is there a single database file housing all the data, data definitions, stored procedures, security, table relationships, etc. as in Microsoft’s SQL server?
No, each table is a data file and there are 3 to 9 files which contain the data definitions, stored procedures, security, table relationships, triggers, etc.. which are the DDFs. This provides better overall data integrity so that if one table gets corrupted then the whole database isn’t hosed (that’s a technical term . Q: Does the SQL engine have scheduler capabilities to run stored procedures or other VB scripts designed to access and affect data A: The SRDE (SQL Relational Database Engine) has full stored procedure and trigger capabilities which are data event triggered so it has no need of a scheduler. If you desire scheduled actions to take place and invoke stored procedure and/or triggers it is quite easy to write a small service to do so or even convert a script into a service on NT (chron will do it on Unix and I’m sure there must be a simliar service for NetWare) and make it happen.
