프로시져 열어보니 입력인수 2개네요.

db명하고 파일명하고..

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

create procedure sp_attach_single_file_db
@dbname sysname,
@physname nvarchar(260)
as
declare @execstring nvarchar (400)
set nocount on
 IF ((@dbname is null OR datalength(@dbname) = 0) OR
    (@physname is null OR datalength(@physname) = 0))
 begin
  raiserror (15004,-1,-1)
  return (1)
 end

 select @execstring = 'CREATE DATABASE '
  + quotename( @dbname , '[')
  + ' ON (FILENAME ='
  + ''''
  + REPLACE(@physname,N'''',N'''''')
  + ''''
  + ' ) FOR ATTACH'
 exec (@execstring)
if @@error <>  0
 begin
  -- No need to raiserror as the CREATE DATABASE will do so
  return(1)
 end
 -- strip out replication from this database
if exists (select * from master.dbo.sysobjects where name=N'sp_removedbreplication')
 begin
  exec sp_removedbreplication @dbname
 end
 return (0) -- sp_attach_single_file_db

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

자세한 설명은 온라인 설명서에...