Here is one way:
Add triggers to your source table(s) which modify a set of fields on update or insert of a row.
That way you can track changes to individual rows and only update what has changed.
e.g.
add fields called 'modified', 'modification_datetime' etc to source table.
Every time...
I know Report Builder is obsolete and should be replaced...but I'm stuck with it for the moment, and it all works fine except for one thing:
Is there a way to change the name of the print-job/document-name in Report Builder?
As far as I can tell Report Builder will always generate a print job...
Looks like a bug in the backup according to that Progress kb...
Anyway:
probkup online [database.db] [backupfile] >> [logfile.txt]
And the backup completes just fine according to log...haven't tried restoring the backup yet, but we've never had issues with restoring our databases.
Backup...
Thanks for the help guys, I'll see if service pack 4 fixes the problem.
That kb article pretty much sums up the problem, except for the fact that only SQL connections are refused.
I had already suspected the back-up process was the cause, but I had not done any further investigation...
To get...
30 minute timeout...yet connections accumulate over a 3 month period...
I suspect I've only got two options:
Do a scheduled reboot every month or so on each server,
or
try and identify the offending application/task/process by process of elimination :(
I wonder if anyone has seen this one before:
The number of 'active' connections to our database(s) keeps going up, even though the number of actual connections remains quite low.
I suspect that somehow we have connections to the database that are not being disconnected. The number of 'active'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.