指定的文件组不存在,不指定文件组应该可以创建,尝试如下脚本:
-----------------------------------------------------------------------------------------------------
USE CurrentData
GOIF OBJECTPROPERTY(OBJECT_ID(N'dbo.CANFundOperation'), N'IsUserTable') = 1
DROP TABLE dbo.CANFundOperation
GOCREATE TABLE dbo.CANFundOperation (
FundId CHAR(10) NOT NULL,
RRSP BIT NULL,
RESP BIT NULL,) --ON CurrentData_Data
GOALTER TABLE dbo.CANFundOperation WITH CHECK ADD
CONSTRAINT pk_CANFundOperation PRIMARY KEY NONCLUSTERED
(
FundId
) --ON CurrentData_Index
GO
-----------------------------------------------------------------------------------------------------
USE CurrentData
GOIF OBJECTPROPERTY(OBJECT_ID(N'dbo.CANFundOperation'), N'IsUserTable') = 1
DROP TABLE dbo.CANFundOperation
GOCREATE TABLE dbo.CANFundOperation (
FundId CHAR(10) NOT NULL,
RRSP BIT NULL,
RESP BIT NULL,) --ON CurrentData_Data
GOALTER TABLE dbo.CANFundOperation WITH CHECK ADD
CONSTRAINT pk_CANFundOperation PRIMARY KEY NONCLUSTERED
(
FundId
) --ON CurrentData_Index
GO
是可以运行,也不报错
但是运行完了以后没反应
数据库中并没有新建任何东西
还是没动静
我在数据库属性中建了一个filegroup
这次查询分析器报告:
Could not find stored procedure 'CurrentData_Index'.
以前自己运行脚本的时候从来没用过filegroup、stored procedure
有什么解决办法吗