讨论以下存储过程为什么调试不通过？？？？？？？？？

Question

小生修改成
@filename1=Nc:\mssql7\data\linshi.mdf,
@filename2=Nc:\mssql7\data\linshi_log.ldf
照样不行~why？

Answer 1

下
        exec sp_attach_db @dbname=linshi,
        @filename1='d:\mssql7\data\linshi.mdf',
        @filename2='d:\mssql7\data\linshi_log.ldf'

Answer 2

 exec sp_attach_db @dbname=linshi,
        @filename1=N'd:\mssql7\data\linshi.mdf',
        @filename2=N'd:\mssql7\data\linshi_log.ldf'

Answer 3

经过修改
exec sp_attach_db @dbname=Nlinshi,
@filename1='c:\mssql7\data\linshi.mdf',
@filename2='c:\mssql7\data\linshi_log.ldf' 
变了一个盘符c  加了一对引号
就可以了