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
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"...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.