re-adding a removed extended stored procedure

Hi everyone,
I have recently remove few extended stored procedure on a sql server 2000
sp4 as part of our sql lockdown, including 'xp_getnetname'. When I try to
schedule a DTS job, it get the following error msg:
"Cannot find the function xp_getnetname in the library 'xplog70.dll'. Reason
127"...
I have added xp_getnetname (successfully!) using:
EXEC sp_addextendedproc 'xp_getnetname' ,'xplog70.dll'
BUT i still get the same error message. I am ABLE to use "sp_helptext
xp_getnetname" which gives me "xplog70.dll" as the output but I don't know
why I cannot execute it.
Thanks
"I saw it work in a cartoon once so I am pretty sure I can do it."Found the problem, the SP is in the xpstar.dll
--
Senior DBA
MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Sas" wrote:

> Hi everyone,
> I have recently remove few extended stored procedure on a sql server 2000
> sp4 as part of our sql lockdown, including 'xp_getnetname'. When I try to
> schedule a DTS job, it get the following error msg:
> "Cannot find the function xp_getnetname in the library 'xplog70.dll'. Reas
on
> 127"...
> I have added xp_getnetname (successfully!) using:
> EXEC sp_addextendedproc 'xp_getnetname' ,'xplog70.dll'
> BUT i still get the same error message. I am ABLE to use "sp_helptext
> xp_getnetname" which gives me "xplog70.dll" as the output but I don't know
> why I cannot execute it.
> Thanks
> --
> "I saw it work in a cartoon once so I am pretty sure I can do it."

RDL file not maintaining Extended File Properties

Please try this if you want...
1 For a .RDL file, right click on the file its self and select
"properties"
2 Click the "Summary" tab and enter information in any of the text
fields (Subject, author, ...)
3 Save it and then copy the file on another computer, is your metadata
missing just like mine?
It seems to be saving it somehow locally, but does not transfer with
the file. What gives?
We were originally trying to add some of the install info in here, but
seems to only be local.
Weird thing is... if you look at the same file over the network from
another computer, the information looks to be there, it looses it when
copied.oh well. I just found out why. This data is actually stored in NTFS
and is not in the file. Any time the file is copied into source safe
or email all properties are lost.