Hello Tom,
You didn't mention the logfile size limits. Deleting a lot of
records can easily fill up the log file and SQL server will roll everything back.
Oh my god. More than once I have deleted records, SEEN it delete, but then seen them later when I ran a fresh select query. I thought I was braindead from sleep deprivation and had the numbers wrong. So maybe I've been deleting and it's been restoring them?!
Of course, you don't have to run the query on your host's computer. Setup a Cfserver where you are and connect to SQL server remotely. Just use the IP address of the server with your login credentials. Then run the queries on your dev server
at home/work. No timeout restrictions there :)
I have CF Studio with the single developer license, I run scripts locally, and I'm using SQL Enterprise Manager on my own machine, connecting to the IP of the remote server with my login info remotely. This (as well as on the website scripts) is where I am getting the timeout error.
After seeing your message I went to looking through SQL EM for
settings. The Tools > SQL Server Configuration Properties said
administrator only (I can't access that apparently), but the Tools > Options > Advanced tab has a field for 'query timeout'. It said 0 in there (default, I've never touched that). I entered 500 in there to see if it mattered, finished it, and then went and tried running the same query. Same result in this case, '61' instead of '60' (0 records to delete--running same query I ran successfully earlier). Is there someplace else in SQL EM that I should be doing something to "expand a timeout value"??
> However, you can write a stored procedure
I know nothing of this with logs; having always been remotely hosted it's not something I've had to deal with so far. Thanks a ton for that idea. Can I privately pay you via paypal to just write it out with my values and instruct? My hours/+ and sleep/- the last 2 weeks are making me desperate.
Best regards, PJ
--- [This E-mail has been scanned for viruses.]
----------------------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
