Link to home
Start Free TrialLog in
Avatar of eemmpph
eemmpph

asked on

How can I view customer records in a Microsoft SQL Server 2008 database?

My client has a Windows 7 Pro computer, with Microsoft SQL Server 2008 installed, along with its associated database.  I have been given a copy of the SQL database on an external drive.

I need to extract WordPerfect documents for a particular customer name Joe.  However, I do not have the SQL software to do this.    

In the directory containing files for all customers, I do see the four files that should be of some help:  They are:

joe.emr (containing data:  o(xtoxt . . . )
Joe.idx (containing data:  000000000010000  000000000020000 . . . 000000017500000)
Joe.mst (contains data:  000000000010000Glen Ward   000000000020000Ken Shine . . . )
Joe.pnd (containing data:  000000000010000  000000000020000 . . . 000000017500000)

My question is, how can I view the SQL database (or at least these 4 files),  

Note:  I noticed on the Microsoft website there is SQL 2008 Server Express software, would that work?

Thanks for your help!
SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of eemmpph
eemmpph

ASKER

Thank you David.  Once I searched for the correct file extensions, I did find the LDF and MDF files.

Thank you TLRJohn for answering the question of using SQL Express to view the database.

I appreciate both of you, and your level of expertise in providing the solution.