October 12, 2012 at 10:48 am
There is a setting on my database that causes the followwing to error out:
CREATE TABLE [dbo].[AG_BenefitsQ2Upload$](
[ACCT#] [float] NULL,
[Benefit8Yr] [float] NULL
)
But the following will run fine:
CREATE TABLE [dbo].[AG_BenefitsQ2Upload$](
[ACCT#] [float] NULL,
[Benefit8Yr] [float] NULL
) --)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [FG_012NGR_Data]
--ON [FG_016DCR_Data]
GO
I need to be able to run first create script without error. How can I do this?
October 12, 2012 at 11:01 am
Did you try adding a file group to the first CREATE?
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
October 12, 2012 at 11:12 am
The reason I need to be ablee to work it without the filegroup is that I'm using a Transfer SQL Server Objects Task to copy about 200 tables over and I'm getting the error then as well. I'm assuming it used the "On Primary" with its table creation?
October 12, 2012 at 1:00 pm
You want help resolving an error, but haven't included the text of the error message. That's like going to the doctor and asking him to help you without telling him what your sympoms are. Yes, sometimes it will be completely obvious without that information, but most times it's not.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply