TW, maybe you can have that job chunk up the delete? Have it delete only a few rows at a time to min the impact.
--
---
Douglas Knudsen
http://www.cubicleman.com
"If you don't like something, change it. If you can't change it, change your attitude. Don't complain." - Maya Angelou
its adv. sql server 2000
its a sql job.
that aside.
my bigger problem with this...
how does cfmx server/how should cfmx server handle a database that
just is too busy to feed back a requested recordset? should it crash
the cmfx server? or not?
this is the bigger problem, i think.
ill fix the db. whats the problem with cfmx?
tw
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
