Search results for query: *

Does the same happend in development? I had this problem once. Everything worked on our dev server but would Timeout on Production. We checked all the settings and they were the same. The production server was way more powerful then dev. server too. Finally we checked and found out that one...

I have to execute a DTS package from a stored procedure. THis is my stored procedure: ------------------------------------------------------- CREATE PROCEDURE dts_staging_to_production AS EXEC xp_cmdShell 'dtsrun /S[servername] /U[username] /P[password] /N[dts package name] GO...

How do I remove the trailing semicolon? My results prints out: general, 3/47:31; 4/11:45; I need it to print out: general, 3/47:31; 4/11:45 without the semicolon on the end. Any sugestions? Thanks I would appreciate any help

Actually this is exactly what the print results of the strQuery return. -- EXEC multipleIndexA '10945,6224,10945'

Two variants? Actually I get the values for @inventory_item_id from my ASP page. In the asp page inventory_item_id is being build as a string so: when I print out inventory_item_id is 10945,6224, 10945 then i execute the stored procedure by : strQuery = "EXEC multipleIndexA&quot...

I am trying to pass a string to the stored procedure by doing this: EXEC multipleIndexA @inventory_item_id=' 4935,11105, 4935' I am not getting any results. Now here is the code of my stored procedure: CREATE PROCEDURe multipleIndexA (@inventory_item_id varchar(500)) as create table...