could not find stored procdure xp_availablemedia

hi.
I am getting this error when I try to restore database from device
and try to choose 'filename'.
It's apparently I am missing xp_availablemedia stored procedure, but
where can I get a copy of this and put it in?
Please don't say I need to install full sqlserver again.Try this first:
SELECT * from master..sysobjects where LOWER(name) = 'xp_availablemedia'
How many rows did it return?
If zero, try
sp_addextendedproc N'xp_availablemedia',N'xpstar.dll'
Make sure you are logged on as sysadmin and are in the master database
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<jkim65@.socal.rr.com> wrote in message news:1111731156.502015.190160@.l41g2000cwc.googlegroup
s.com...
> hi.
> I am getting this error when I try to restore database from device
> and try to choose 'filename'.
> It's apparently I am missing xp_availablemedia stored procedure, but
> where can I get a copy of this and put it in?
> Please don't say I need to install full sqlserver again.
>|||it says
could not find stored procedure 'master.dbo.xp_fixeddrives'.
I guess maybe a bunch of stored procedure in master was deleted for
some reason.
I think I am going to somehow copy these stored procedures from some
other machine.
thanks for the reply.|||> could not find stored procedure 'master.dbo.xp_fixeddrives'.
Are you saying that below query, executed from Query Analyzer returned that
error?
SELECT * from master..sysobjects where LOWER(name) = 'xp_availablemedia'
If so, you have some serious issues with your installation.

> I think I am going to somehow copy these stored procedures from some
> other machine.
These are not regular stored procedures. The code for extended stored are in
DLL files, and the code
I posted earlier adds the code in the DLL file to SQL Server so it is access
ible through TSQL. Did
you try it? Here it is again:
sp_addextendedproc N'xp_availablemedia',N'xpstar.dll'
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<jkim65@.socal.rr.com> wrote in message news:1111945063.141236.209750@.f14g2000cwb.googlegroup
s.com...
> it says
> could not find stored procedure 'master.dbo.xp_fixeddrives'.
> I guess maybe a bunch of stored procedure in master was deleted for
> some reason.
> I think I am going to somehow copy these stored procedures from some
> other machine.
> thanks for the reply.
>