#1
  1. No Profile Picture
    Contributing User
    ASP Discoverer (100 - 499 posts)

    Join Date
    Aug 2008
    Posts
    110
    Rep Power
    0

    Display data and tables in an mdf file sqlserver 2000


    Please help me on how to use sqlserver 2000 and display all the tables in the mdf file and export them to excell
  2. #2
  3. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Mar 2005
    Location
    Columbus, OH
    Posts
    1,665
    Rep Power
    283
    just run
    SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
    GK
    __________________________________________________ _____
    if you found this post is useful click Give Rep button (bottom side on this reply ) and agree

Similar Threads

  1. Using if statement in sqlserver 2000
    By makumbi in forum Microsoft SQL Server
    Replies: 2
    Last Post: March 20th, 2009, 02:42 AM
  2. Need help on helpdesk application.(vb.net , sqlserver 2000)
    By yasinirshad in forum .NET Development
    Replies: 1
    Last Post: August 1st, 2007, 08:30 AM
  3. Getting Back Up Only Few Tables OF Sql Server 2000 Data Base
    By amna in forum Microsoft SQL Server
    Replies: 3
    Last Post: December 12th, 2005, 08:38 PM
  4. Insert images in sqlserver 2000 using asp.net
    By rsurays in forum .NET Development
    Replies: 3
    Last Post: April 24th, 2005, 10:53 PM
  5. Return value from SQLSERVER 2000
    By rkonara in forum ASP Development
    Replies: 1
    Last Post: June 7th, 2004, 12:11 PM

IMN logo majestic logo threadwatch logo seochat tools logo