Home Forums Article Discussions Article Discussions by Author Discuss content posted by Joshua A. Walker Search All SQL Script Objects in All Databases for Text RE: Search All SQL Script Objects in All Databases for Text

  • March 16, 2009 at 12:58 am

    #960057

    This script crash when a database is offline:

    A simple where condition should is missing:

    SELECT [NAME] FROM Master.dbo.sysdatabases

    WHERE [NAME] NOT IN ('MASTER', 'TEMPDB', 'MSDB', 'MODEL')

    AND Status & 512 = 0

    Regards,
    Yenidai