I am Getting an error as below, when I make any changes and give Ok button in an Existing Stored procedure (Sql Server 2000)
Error 21001: [SQL-DMO]Stored procedure definition must include name and text (for Standard StoredProcedure) or libraryname (for Extended StoredProcedure).
How to rectify this problem please advise me....
Answer by Kev Riley ·
Are you editing an existing SP?
Does the code work fine if you create the SP using Query Analyzer rather than the GUI in Management Studio?
What is the result of running
select * from sysobjects where name like '%PayrollProcessing%'
making sure you are in the database where that procedure exists