different stored procedure names when opeing file on different machines

W

WB

I have an adp file that shows the correct stored procedure names.

When I open the same file on a second machine, the names are the same until
the very end. somehow, the names all show a semi-colon followed by the
number one.

ex:
sp_someName;1

How do I prevent this?

WB
 
S

Sylvain Lafontaine

This is a very old bug, you should apply the latest service pack for Office.
 
H

hbk25018

WB said:
I have an adp file that shows the correct stored procedure names.

When I open the same file on a second machine, the names are the same until
the very end. somehow, the names all show a semi-colon followed by the
number one.

ex:
sp_someName;1

How do I prevent this?

WB

sorry I don'know too
 
A

aaron.kempf

technically

storedproc;1
storedproc;2
storedproc;3

if you create 3 sprocs with this name; and then you say 'exec
storedproc' it will fire all 3 behind the scenes right?

and 'drop procedure storedproc' would delete all 3 of those also right?

i saw that in 'sql 7 secrets' and i always knew it would come in hand
sometime

-aaron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top