Question

SQL语句无法执行高手帮忙分析

语句如下,其中ETeam-PMS-DB为数据库名,该语句在查询分析器中可执行,但在企业管理器中无法添加作业进行自动执行.SELECT * FROM ETeam-PMS-DB.dbo.sysfiles
use ETeam-PMS-DB
BACKUP LOG ETeam-PMS-DB WITH TRUNCATE_ONLY
DBCC SHRINKFILE(ETeam-PMS-DB_Log,10)

错误提示如下:
---------------------------
Edit Job Step - (local)\clearETeam-PMS-DB
---------------------------
The Server detected the following syntax errors in the command:
Error 911: Could not locate entry in sysdatabases for database 'ETeam'. No entry found with that name. Make sure that the name is entered correctly.
Line 1: Incorrect syntax near '-'.
Are you sure this is what you want?
---------------------------
Yes No
---------------------------
经查为数据库命名中不能有"-",是否为这个原因,查为什麽能在查询分析器中执行,出高分请高手解答.
用方括号把数据库名括起来试试
比如:use [ETeam-PMS-DB]

如果还不行,建议你在存储过程中执行,并给这个数据库一个别名
回答者：shaoling_cn - 试用期 一级 1-31 12:10

Answer 1

SELECT * FROM 'ETeam-PMS-DB.dbo.sysfiles'

Answer 2

http://web.java-asp.net/doc/p338/J33841632.shtml