Err: Can't find proc: sp_attache_single_file_db

  • In Sql Server 2005, When I try to restore a database, i get the error that the procedure sp_attache_single_file_db doesn't exist. Does anyone know why?

    I'm logged in as the sa.

    exec sp_attache_single_file_db @dbname = 'TEST', @physname='C:\temp\test.MDF'

  • once again, I figured out my issue. I had an "e" after the word attach. I figured the "e" was expected because I copied the stored procedure from another post and I figured that maybe microsoft was using some kind of french terminology. I removed the "e" and it worked.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply