SQL Server - Stored procedure
-
Hi all, Is there any way to check whether a stored procedure is present in the Database or not. Iam using SQL Server as the db and using ADO 4 programming using MS VC++ 6.0 Thanx in advance Sujan Note: I KNOW THAT WE CAN CHECK IT USING TRY-CATCH,IS THERE ANY OTHER WAY OTHER THAN THIS
-
Hi all, Is there any way to check whether a stored procedure is present in the Database or not. Iam using SQL Server as the db and using ADO 4 programming using MS VC++ 6.0 Thanx in advance Sujan Note: I KNOW THAT WE CAN CHECK IT USING TRY-CATCH,IS THERE ANY OTHER WAY OTHER THAN THIS
-
use the same query that the SQL generator to see if the stored procedure is there. It is a query of dbo.master.sysobjects. Tim Smith I'm going to patent thought. I have yet to see any prior art.
Hi Tim, Thanx a Lot i'll work with it. Sorry for replying late coz yesterday i not @ the office. Thanx a Lot Sujan