Recent content by ktucci

i have a request that requires the use of a 2-byte header for an SSL transaction. i posted below the requirement and the code snippet where the 2-byte header designation would go. if anyone can offer any assistance into this, it would be greatly appreciated. thanks in advance. here is spec...

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

i have this OCX that runs inside of our biling system that allows users to choose jobs and billing periods to run. by choosing a billing period, i then need to relate the billing period info to the job. so i use DMO and basically have a template job that sits out there and never gets run but...

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