different stored procedure names when opeing file on different machines

  • Thread starter Thread starter WB
  • Start date Start date
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
 
This is a very old bug, you should apply the latest service pack for Office.
 
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
Click to expand...
 
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
 
Back
Top