find the all the stored procedures and jobs in sql server 2000
- by kumar
Hi,
In SQL SERVER 2005 This query works fine : Select * from sys.procedures where object_definition(object_id) like '%J%'
SELECT * FROM MSDB.DBO.SYSJOBS WHERE NAME LIKE '%J%'
but in sql server 2000 it is not working. Here i need to find the all the stored procedures and jobs which matches my string ? how to find in sql server 2000 ?
regards,
kumar