| Author: Kapil Dhawan 16 Jun 2008 | Member Level: Gold Points : 2 |
Hello,
Thanks for sharing your knowledge with us.
Will this code work for extended Store procedure also.
I will appreciate if you can explain this more.
Regards,
Kapil
|
| Author: PRAVEEN PANDEY 16 Jun 2008 | Member Level: Silver Points : 2 |
HELLO DEAR I HAVE USED THIS CODE FOR KNOWING THAT OUR PROCEDURE
IS PRESENT OR NOT BUT ITS NOT GIVING PROPER RESULT.
I HAVE USED THIS.
use sp_helptext <proc-sp_Promotion_Select
BUT ITS SHOWING ERROR
Could not locate entry in sysdatabases for database 'sp_helptext'. No entry found with that name. Make sure that the name is entered correctly.
|
| Author: Bunty 16 Jun 2008 | Member Level: Diamond Points : 2 |
Hi,
Praveen,You use the sp_helptext in the current database in which the stored procedure is present.Hope this information is useful to you.If you still got the problem let me know.
|
| Author: Bunty 18 Jun 2008 | Member Level: Diamond Points : 1 |
Hi,
Kapil Dhawan.Sorry the above will not work for Extended Stored Procedure.
|
| Author: lavanya 07 Aug 2008 | Member Level: Gold Points : 1 |
You can check it like this
if exists(select * from sys.objects where type = 'P' and name = 'stored procedure name')
do ur insertion or deletion
go
|