| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> Halo_Four: o sure if you want to get into fancy stuff like that :)
<1> how SicLuDe, I'm not familiar with tracing in sql (otherwise I'd have done that)
<1> as is, i'm running through the query piece by piece
<1> and each individual piece works just fine
<0> look throgh the menus
<1> haha k
<1> oh sweet
<2> evening
<1> g'day
<3> yo
<4> yo
<1> it seems to be freezing in the middle of a single query, but that query works
<1> the only thing the sp does before that query is call another stored procedure
<5> so run that sp then the query
<1> so tracing didn't help much there
<1> that's what I'm doing already, but it doesn't work?
<6> well cover my *** in potato salad and call me geoffrey, i dunno what to do about this sql 7 problem
<7> http://homepage.mac.com/pockyrevolution/Personal25.html
<2> hey geoffrey!
<4> that Tom Cruise killing Oprah was hilarious
<7> yea...
<1> OH
<1> http://sql-servers.com/nopaste/?show=152
<1> joyeuse.
<8> moofluffy, yay ... you broke it!!!!
<1> what? D:
<1> i'm seeing: http://support.microsoft.com/default.aspx?scid=kb;en-us;306212&Product=sql2k
<1> so hopefully there's just a loopback somewhere
<8> read the msdn article on resolving the issue, heh
<1> i am
<1> *did, actually
<1> and am looking over all the views and sps that get called now
<1> heh
<9> sigh
<9> I know I've asked this Q before and I apologize for asking it again but has anyone worked with one of the third-party encryption providers for SQL Server 2000 which they can recommend given DB sizes around 100-150GB without bringing the system to it's knees?
<8> the dts designer is an mmc snapin ... so when you run the package through the designer, the mmc.exe process is the one eatting up resources and memory, correct?
<9> zoul: Yes
<10> its amazing the stupidity of people, especially in the emails you receive when you are out of the office
<9> hm, at least I think so. It's possible that it shells out to dtsrun.exe, but I'm not sure of that.
<8> Halo_Four, yeah, I was gathering as much as I'm watching mmc.exe eat up ram and cpu like crazy as this package executes this ridiculous activex script
<11> lol
<8> the script opens up a text file, which is around 25mb ... into a FileSystemObject ... then goes line by line, removing whitespace and newlines, then writes the data back out to a new text file ...
<11> OMG ITS PUTTONG ON WEIGHT FASTER THEN OPRA WINFREY AND ROSIE ODONNEL
<9> fun
<8> ironically, the DTS transform object can do all this work during the initial data dump ...
<8> Arrakis, every now and again your funny ...
<8> but not this time
<11> :p
<8> and this things taking 10 minutes so far
<11> that there is funny, i dont care what you say
<8> so roughly, the transform, then the script process ... combined, take about 15 minutes ...
<8> hahaha ... but doing it all in the transform component takes under 45 secons
<8> LMFAO
<12> :P
<12> how's it going?
<8> not bad, you ?
<8> I'm doing a diff on this stupid *** file, to see where the extra 20 btyts come into play, haha
<9> No encryption recommendations, eh?
<12> could be better
<12> Halo_Four encryption what
<12> for a communication link?
<9> Darken: No, encryption libs for SQL2K
<6> boooo WITH STATUSONLY isnt avail ins sql7
<2> Rizar_d : ms-sql7 is two versions old... get with the program...
<13> haha
<13> get in the game
<6> he needs to get with a new internet connection ;p
<7> whoa Jarett__
<7> that was a bit much wasn't it
<10> nope
<7> it's just a bot
<10> its a bot with feelings :P
<7> :O
<7> tell it I'm sorry then
<7> I didn't know you oracle junkies were so good at ai
Return to
#sql
or
Go to some related
logs:
legitcontrolcheck crack
troglidites
anatomy of a stryker
#ubuntu
#worldcup
Dodge Challenger Conzept .wmv
steel factory Pitsburg
how to humiliate the submissive male
#dsl
#nhl
|
|