Home Forums SQL Server 2005 Development user tables in database where the number of rows is less than 100 RE: user tables in database where the number of rows is less than 100

  • January 17, 2009 at 1:49 pm

    #928737

    Thanks so much. Somehow I am not able to run the command. I am sure that you would have got the correct result of your respective queries ...

    Msg 208, Level 16, State 1, Line 1

    Invalid object name 'sys.partitions'.

    select @@version:

    Microsoft SQL Server 2000 - 8.00.2050 (Intel X86) Mar 7 2008 21:29:56 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

    select * from sysobjects where name like '%partition%' --> No row is selected

    Your query is good for 2005 but what should I do for 2000 🙁

    -M

    -MJ
    Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.