[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Any proactive schema lock for exclusive access to perform database changes (SQL92 DDL)?

  • Thread starter Thread starter dbeavon
  • Start date Start date
Status
Not open for further replies.
D

dbeavon

Guest
Yes, that is the type of thing I'm looking for on SQL92. Only I would want to lock it in my SQL connection, and perform a number of DDL commands and then commit at the very end. The end goal is just to be able make schema changes without an interference from all the other (potential) clients of the database. What do you think of the idea of temporarily starting the database with a different port number, just for the purpose of dictionary changes? I'm starting to think that is a far more straightforward solution than anything else I've come across.

Continue reading...
 
Status
Not open for further replies.
Back
Top