Hi Tim,

I was thinking it would be nice to have a way to set a "Startup" script that could be run everytime edbsrvr is started. It could be used to set those non-persintent properties such as "SET BACKUPS", "SET FILES", etc. and some other configuration chores such a validate a license key, etc.

I could be implemente as a external SQL file that edbsrvr looks up to when it is starting or have way to mark some stored procedure as "ExecuteOnStartup" attribute.

What do you think?

Regards,
Mario

Mario,

<< I was thinking it would be nice to have a way to set a "Startup" script that could be run everytime edbsrvr is started. It could be used to set those non-persintent properties such as "SET BACKUPS", "SET FILES", etc. and some other configuration chores such a validate a license key, etc.

I could be implemente as a external SQL file that edbsrvr looks up to when it is starting or have way to mark some stored procedure as "ExecuteOnStartup" attribute.

What do you think? >>

I think that it's such a great idea that I've already implemented it ( ):

https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=CREATE_JOB

(specifically, the AT SERVER START interval type).

However, please note that using the SET statements that you mention in such a job won't have any bearing on other sessions.  The SET statements are session-specific, and jobs are executed in their own session context.

Tim Young
Elevate Software
www.elevatesoft.com

Hahahaha... great!

I take look it then, thank you for the heads up!

Regards,
Mario