• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 731
  • Last Modified:

SQL 2000 attach database getting Error 2812

Trying to attach database to SQL 2000. Getting the following:
MIcrosoft SQL-DMO (ODBC SQLStates: 42000)
Error 2812: Could not find store procedure 'master.dbo.xp_fileexit'.

Any suggestions to how I can attached database?
0
Boomer8387
Asked:
Boomer8387
  • 2
1 Solution
 
Scott PletcherSenior DBACommented:
I assume that should be "xp_fileexiSt".

Verify that you have entered all the file paths and names correctly.  [Remember, the drives/paths are SQL Server's drive/path mappings, not your logins.]
0
 
Boomer8387Author Commented:
I endup restore the databases from my tape backup. Thank you for your reply,
0
 
Boomer8387Author Commented:
I restored the database from tape backup instead of attaching the DB
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now