Prev: Cascade delete
Next: SQLServer Error: 802, 701, 733
From: Muhammad Bilal on 2 Aug 2010 07:46
Hi.

When i create a procedure following error is generated in sql server 2000.

Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'xp_cmdshell'. The stored procedure will still
be created.


Regards,
Muhammad Bilal
From: Erland Sommarskog on 2 Aug 2010 15:19
Muhammad Bilal (MuhammadBilal(a)discussions.microsoft.com) writes:
> When i create a procedure following error is generated in sql server 2000.
>
> Cannot add rows to sysdepends for the current stored procedure because
> it depends on the missing object 'xp_cmdshell'. The stored procedure
> will still be created.

That is not an error message, but an informational message.

However, it indicates that you have failed to include the database
specification in the procedure call:

EXEC master..xp_cmdshell

It is only system procedures that start with sp_ that you can call without
specifying the database name.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: Scott Morris on 2 Aug 2010 15:21
"Muhammad Bilal" <MuhammadBilal(a)discussions.microsoft.com> wrote in message
news:275E58BE-B564-4FE5-8475-A74DE91BA51B(a)microsoft.com...
> Hi.
>
> When i create a procedure following error is generated in sql server 2000.
>
> Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object 'xp_cmdshell'. The stored procedure will
> still
> be created.

It is a warning, not an error. The procedure was successfully created, which
the message indicates.


 | 
Pages: 1
Prev: Cascade delete
Next: SQLServer Error: 802, 701, 733