Post reply

Articles of a database

  • September 23, 2005 at 1:03 pm

    #168868

    Whats the best way to identify  all tables that are not in sysarticles of each database? Does anyone have  a script handy for this? Any help is greatly appreciated.

    TIA

     

  • September 23, 2005 at 1:30 pm

    #592742

    Look @ sysobjects WHERE xtype = 'U'



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • September 23, 2005 at 1:44 pm

    #592750

    I know from sysobjects you get all tables where xtype= 'U' but what i need is to know which tables are replicated and which arent.

    TIA

  • September 23, 2005 at 2:01 pm

    #592762

    just add "Where not exists in sysarticles" to your select from sysobjects

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

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