This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I'm trying to update my SQL Server database from LightSpeed designer. This update fails, and the reason for the failure is that apparently LightSpeed cannot cope with certain constraints that were introduced to the DB in the meantime (not through LightSpeed). Now, I would like to take the SQL script that LightSpeed is attempting to run and to apply it manually with a few adjustments. However, the problem is that when the update fails, LightSpeed does not display the SQL log that I could use for this purpose (the "Log SQL" checkbox is checked of course). In fact, no error message is displayed either (it all looks exactly as it would if the update were to be successful). Although the usual checkbox tree does appear in the beginning, clearly having the actual SQL script at my disposal would be much more convenient and would save a ton of time. Does anyone have any recommendations? Also, is there some way to intercept the SQL commands that LightSpeed is trying to run and view them as text? Thanks! |
|
|
|
