Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: SQL to identify what proc''''s use a specified table

    This may be a li'l overkill, but it searches all databases and handles multiple search values as well.

    SET NOCOUNT ON

    /* Declare Variables */

    DECLARE @Database     VARCHAR(100)

    DECLARE @TextToFind   VARCHAR(100)

    DECLARE @Lit       VARCHAR(1)

    DECLARE @Select VARCHAR(5000)

    SET @Lit =...

Viewing post 1 (of 1 total)