SQL Server (XP/2K)

Topic

New Reply

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 . Any pointers or where do I look for guidance?
Thanks

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

|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.

Reply | Quote

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?

Reply | Quote