Post reply

Management Studio Filtering Options

  • November 1, 2010 at 3:33 pm

    #228697

    Does anyone know of a way to filter which tables are displayed in management studio based on Extended Properties ? Or to set up a filter using (Name contains 'xyz') OR (Creation date > yy/mm/dd )

    If you specify both it applies them as AND conditions

  • November 1, 2010 at 10:47 pm

    #1245194

    I did not understand your question correctly.

    Please try this query and reply....

    SELECT * FROM sys.tables WHERE name LIKE '%xyz%' AND create_date >= '20101102'

  • November 2, 2010 at 8:34 am

    #1245429

    In management studio object explorer, there is an option to filter which objects are displayed. The limitations I'm trying to get past are in setting up that filter. If the filter had an option to run an sql query that would do it, but it does not

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply