Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    SQL Server (XP/2K)

    I am trying to learn something new about the SQl server I installed the MSDE backend engine. I then tried the upsizing wizard in Access.
    First the main table did not upsize. I tried the change of the registry in KB article about the query timeout, that did not help. When I tried importing only the structure of the table, that worked. However I do not know how to view the SQL server tables directly.
    How can I see them? IS there some hidden program that allows me to manage them? I cannot find the files on my drive? What is their extension?
    As you can see I am completely befuddled <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> . Any pointers or where do I look for guidance?
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SQL Server (XP/2K)

    I have no experience with SQL Server to speak of, but as far as I know, SQL Server Enterprise Manager is the "interface" for it.
    And you can use Access as front end to view tables, of course.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL Server (XP/2K)

    You can use a number of things to 'view' sql server tables.

    The easiest for you is to probably use MS Access. Create a new MS Access Project (.adp) file. You will need to enter the appropriate server name (the name of your computer) and the like, including the SQL Server Database Name. Once you have done this, you will be able to view the SQL Server objects in the MS Access Project (.adp) file.

    You could also use Enterprise Manager, or if you wanted to get really tricking, search for a command line tool, called osql.exe, you can type in the commands manually using this (ie. select * from tblName).

    I think MS Access would be your best bet for basic functionality.

  4. #4
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL Server (XP/2K)

    The 'files' that SQL Server (MSDE) uses, should probably be installed in C:Programe FilesMicrosoft SQL ServerMSSQLData. You do not want to play around with these files unless you really know what you are doing I would guess.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL Server (XP/2K)

    Thanks. I was playing with the upsizing wizard and made all kinds of files, that I could not find to erase.
    I am stuck now trying to upsize the largest table with over 65,000 records. I tried changing the registry to change the ODBC timeout, but that did not help

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL Server (XP/2K)

    |Generally the way you handle this is to upsize the table structures and then use DTS to transfer the data. DTS is available either from Enterprise Manager or from the desktop engine, I believe. The MSDE changed between O2k and OXP, so I'm not sure whether DTS is available in the same way from OXP.
    Charlotte

  7. #7
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL Server (XP/2K)

    I read about DTS but I have not yet figured out how to get to it in XP. The tables all update with the data from the wizard aside from the one with 65,000 records. Could I update just the structure and then run an append query from the local table to the SQL table to get the data in?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •