>I have been asked to get some data out of a SQL database (MSSQL Version 8.00.02).
>
>Does the Hentzenwerke SQL book discuss this process?
>
>Can I take the database standalone files and copy to my SQL server (I have never used it - yet - so I do not know if this is possible).
>
>What would be the best route since every table has field names > 10 characters and they duplicate that 10 character prefix.
If you want to get a copy of their database on your SQL Server so you can play around with it, one easy way is to back it up to a file on their machine, copy the file (to a CD or whatever), then restore it on your SQL Server (backup and restore through Enterprise Manager).
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up