Search results for query: *

...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 =...

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...

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

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

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

...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...

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...

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

my mistake the sp i need to modify is: sp_delete_job

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

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...

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

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

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...

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...

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...

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...

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...

thanks a million, the dynamic sql worked perfect thanks keith

...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]...