Search the Knowledgebase Browse by Category

[Advanced Search]
Attaching The Food Processor Database to your instance of SQL Server 2000
Would you like to...
Print this pagePrint this page
Email this pageEmail this page
Post a commentPost a comment
Subscribe me
Add to favoritesAdd to favorites
User Opinions
85% thumbs up 14% thumbs down (7 votes)
How would you rate this answer?
Helpful
Not helpful

Note: using the ESHA Database with your own instance of SQL Server will require the server collation to be 'SQL_Latin1_General_CP1_CI_AS'.

To attach The Food Processor Database (eshadata) in SQL Server 2000:

  1. Copy the eshadata.mdf file from "[CD]:\win32\program files\ESHA Research\data" into a drive that is local to the server (recommended is "c:\program files\ESHA Research\data").
  2. Check/change attributes on that file so it is not Read-Only.
  3. Start Query Analyzer (part of full SQL Server 2000).
  4. Connect to your server - MASTER database.
  5. In the text enter this (including quotes):
       exec sp_attach_single_file_db @dbname = 'eshadata',
       @physname = 'C:\Program Files\ESHA Research\data\eshadata.mdf'
    NOTE: the @physname parameter should be the path to .mdf from step 1 including extension.
  6. Exit Query Analyzer.
PERMISSIONS NOTE:  After it has been attached you will need to assign permissions for any user that will access the data. Use Enterprise Manager to add the user's Windows Authentication to the role 'FPRole' that exists in the database.  If you are not using Windows Authentication (Active Directory), refer to the Using SQL Authentication document for information.
Attachments
No attachments were found.
Related Questions

Powered by ActiveKB Knowledgebase Software