Re: Delayed Code Execution?

KJ wrote:
Hi Jim,

Glad to hear back from you. I've been thinking a bit more about using a
threaded timer, and I am now feeling that this is not the best
solution, especially for a newer developer.

I think there is an easy way to do this, but it will require some
design work. A few questions first: are you using a database platform
such as SQL Server for your application? If so, do you have much
experience on that platform?

-KJ


I'm running a 2003 server (IIS6) with SQL2000 Standard (also on same web server). I have a little knowledge of it, such as basic SQL commands and basic server administration. I've considered upgrading it to 2005 but always a little nervous about upgrading a production server. Since my databases are very small and I've no large or imperative stored procedures, views or triggers, I'm sure upgrading wouldn't be a problem. I am planning on doing so soon, if I can get over the potential upgrade disaster fear.

The internal website that i've mostly built has about 6 simple databases .. Each database has no more than, say, 6 tables, with maybe two of them related and the others just lookup tables. I've never used stored procedures until recently when I decided to make a few to give them a try, since I heard its the more secure way to go and better performance.

This whole delayed code execution thing isn't completely necessary. It was a side thing I was going to do to make things look a bit less, um, computer controlled. ;)
.

Relevant Pages

  • Re: Informix 11 Upgrade with ER failed - help please - broken sysmaster database
    ... We are in the process of upgrading these to 11.10.UC2W2 - and have hit a roadblock. ... The server is online and working - but ER can't connect - we get "This feature of Enterprise Replication is not yet supported" which is really unhelpful ... The problem is not with ER, the sysmaster database was not able to be built. ... 11:38:31 SCHAPI: Started dbScheduler thread. ...
    (comp.databases.informix)
  • Re: Informix 11 Upgrade with ER failed - help please - broken sysmaster database
    ... We are in the process of upgrading these to 11.10.UC2W2 - and have hit a roadblock. ... The server is online and working - but ER can't connect - we get "This feature of Enterprise Replication is not yet supported" which is really unhelpful ... The problem is not with ER, the sysmaster database was not able to be built. ... 11:38:31 SCHAPI: Started dbScheduler thread. ...
    (comp.databases.informix)
  • Re: Log shipping and error 22029
    ... > Reversing the direction of log shipping is a manual process. ... Promote the secondary database on the Standby server using ... >> After I have run the stored procedures to demote the primary, ...
    (microsoft.public.sqlserver.server)
  • Application concerns OVER Login
    ... setup user on network with only user rights. ... gave that user rights to specific stored procedures on database ... wish to distribute this sql server database on a cd ... is only for the stored procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: Regarding Oracle version upgrading questions
    ... Current database runs on HP-UX 11.11, ... There exist debate on upgrading Oracle8.1.7 to higher version. ... We'd like hear from those who have upgrade their oracle server, ... did oracle 10g or oracle11g just mean to improve business report ...
    (comp.databases.oracle.server)