why does store way i'm job over odbc destroy during same location?
i'm controlling library opening information ms sql server 2000 database (sp3? sp4?). particular, i'm controlling quite enlarged nasty stored procedure. i watch way govern sql profiler, however, tends stop guess during certain point. blunder codes exceptions thrown. i critique out nested matter always final statement, only ends rather before comment. i haven't attempted radically commenting out whole damn thing... i'm sourroundings query timeout 300 seconds. callable matter wholly advantage underneath 1 sec, but indeed finishing sp.
any ideas?
update0: i run sp around query analyzer tool... works. it's only around odbc tie fails.
update1: i critique out code, execution ends offer sp. creates me cruise there timeout aegis border i'm controlling into.
Comments
Post a Comment