Lets you search all db objects for a string.
EXECUTE spFindTextInObjects 'UNION ALL', 1
GO
EXECUTE spFindTextInObjects 'XML EXPLICIT'
GO
EXECUTE spFindTextInObjects 'DECLARE%CURSOR', 1
GO
EXECUTE spFindTextInObjects '@@IDENTITY', 1
GO
Another script from DOS but shows alerts
Like the one posted before, the use of the SP is like this: proc_alerts 1,18. This will show the first 18 alerts on the system. OR proc_alerts 20,35 will show from 20 to 35. This lets you manage the list without letting go out of the screen.
2001-11-03
1,041 reads