Hi Andy I try with TRUNCATE in the QA but I got this error:

Cannot truncate table 'DEMAND_SHPMNT' because it is being referenced by a FOREIGN KEY constraint.

and if I try...

Hi Andy I try with TRUNCATE in the QA but I got this error:

Cannot truncate table 'DEMAND_SHPMNT' because it is being referenced by a FOREIGN KEY constraint.

and if I try...

Well, the service pack and mdactype didn´t work, I have the same problem. I am trying to search with everything you are giving me but I´ve a lot of...

At the beginning was 0 because the person that made that part said that 0 is infinitive tries. Then I modify it to 999999999 (:-D, I really desperate)

What...

Somebody told me that the timeout expired error that I have, could fix it installing Service Pack on VB and mdcatype, do you think it could work with this?

Thanks for...

Hi Patrick, I try increasing the Timeout, but as you say it sometimes works and some not. So do I have to lock the table??

Thanks for your time...

Hi Andy, somebody told me that I should try with TRUNCATE, does it can works??

Thanks 😀

Ana

Edited by - anamoji on 10/23/2001 5:03:18 PM

I wrote the query in the Query Analyzer and didn´t have any problem.

Then I passed it to a sp and start calling it from VB

I take a look to the...

Hi Steven, it is a great tip, thanks for sharing this with us.

Have a great day 😀

ISC. Ana Laura Mojica

Hi Lou did you resolve the Timeout expired problem??, I have the same problem that you have on two stored proceudres that I call from VB.

Can any body help me??

Thanks...

Hi, Alain, did you resolve the problem?

I am having the same problem that you. I´ll tell you what do I do. I have a lot a stored procedures...