Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ktucci

    2-byte header for SSL transaction

    ...header in the first 2 bytes of the TCP/IP send buffer, followed by all 500 bytes of the XML message... here is my code: string payload = "*0210000001.0950003946614.MZ2003000.100340620000.5499992345678903.0908.106.0.aY.30329 4 CORPORATE SQ.....00."; string xmlPackage =...
  2. ktucci

    convert .net code to CF...help...

    i am far ffrom an expert on coldfusion and need to implement some exisitng .net into CF...is this possible, if so could someone point me in the right direction...this below code is what i am trying duplicate in CF and below that is my attempt... any help will be greatly appreciated...thanks...
  3. ktucci

    modify system stored proc

    you got it...'ALTER PROCEDURE' worked like a charm thanks a million
  4. ktucci

    modify system stored proc

    no i havent....let me give that a shot
  5. ktucci

    modify system stored proc

    i tried that orgianlly...sql server does not let you delete system objects...i am not sure if there is modifiable security setting to allow this but it did not work for me thanks for the help i am open to any and all suggestions
  6. ktucci

    modify system stored proc

    ...from. i need a way to pull the history prior to the job being deleted which happens upon completion. simply adding the folling between the ---*** to the sp_delete_job sp will resolve the problem: IF (@delete_history = 1) ---*** insert into...
  7. ktucci

    modify system stored proc

    unfortunately i still need it to be a system stored proc after i modify it and it still needs to be called as it noramlly is from a the process of deleting a job...
  8. ktucci

    modify system stored proc

    any job can be set to delete after it is run, which the ones i am creating are set to do...so there is a disconnect from my app and the jobs
  9. ktucci

    modify system stored proc

    my mistake the sp i need to modify is: sp_delete_job
  10. ktucci

    modify system stored proc

    i know it happens at least when a job is deleted...
  11. ktucci

    modify system stored proc

    i know, but i need to pull some data from the table 'sysjobhistory' before it gets purged by 'sp_purge_jobhistory'. basically i am creating and deleting jobs dynamically using DMO and i need the job history prior to it being purged. i just need to be able to modify 'sp_purge_jobhistory' to...
  12. ktucci

    modify system stored proc

    is there anyway to modify a system stored proc...if so, how...? any help will be greatly appreciated
  13. ktucci

    convert binary data to string

    what is the easiest way to convery binary data to a string in VB.net thanks in advance -keith
  14. ktucci

    simple sql performance question

    thanks auto close is unchecked...the problem is really with an application that spawns executables to run a FOR XML statement...while one is running it takes 30 seconds to complete, but while 2 are running the time doubles for one to complete...the query analyzer example is just so i can...
  15. ktucci

    simple sql performance question

    here is a simple question, but just recently this issue is really causing havoc imagine i have a stored proc that simply select some rows and it takes 10 seconds to run it query analyzer...now imagine i run this same query 2 times concurrently through query analyzer and now it takes 18 seconds...
  16. ktucci

    add and retrieve data to and from array

    i need to store this data returned from a recordset in some sort of an array or collection by looping through the result set: key,f1,f2 1,aaa1,aaaa 1,aaa2,bbbb 1,aaa3,cccc 2,bbb1,aaaa 2,bbb2,bbbb 3,ccc1,aaaa i would then need to retrieve all of the data by requesting the key eg: i would...
  17. ktucci

    store XML string in DB

    how can i best store the XML string resulting from the query below...i presume inserting into an 'image' field would be the answer assuming these XML string will be very large...i was wondering if anyone has any way i can accomplish this inserting of the XML string into an 'image' field through...
  18. ktucci

    need to locate dialog window and sendkeys

    i need to locate a dialog window(my request involves the ssl certificate dialog windows) and sendkeys to 'enter' hese two windows as they appear...i am running a web browser control in my application and dialog window displayed when i access the required page from the browser control...i need to...
  19. ktucci

    sql server 2000 if i pass a stor

    thanks a million, the dynamic sql worked perfect thanks keith
  20. ktucci

    sql server 2000 if i pass a stor

    ...for @var_view and p.preorder_postatus_id has an datatype of integer...how could i convert this variable to and integer so the query can process it *btw...i am passing the string to the stored proc from coldfusion -------------------------------- CREATE PROCEDURE [sp_qry_get_preorders_1]...

Part and Inventory Search

Back
Top