June 25, 2012 at 5:49 am
Configuration: SQL Server 2008 r2 on a Windows2008 server, with 2 processors and 16 GB of RAM
I have a table, which contains about 100 columns, and has about 11-11 million or records.
The table is partitioned on a field, and has 3 nonclustered, nonunique indexes, no primary key.
Our nightly ETL (ssis) populates the table with inserts and updates.
Everything went fine for a few days, but now, Sql Server produces errors on the indexes.
"...Cannot insert duplicate key row in object 'TableName' with unique index 'IndexName'..."
Problem is, there are only 3 indexes, which are all declared as non-unique, and no primary key.
So there is nothing at all that can produce a unique violation.
I have found the following on Microsoft Connect, which is similar to my problem:
The workaround is to drop the indexes before the ETL does his work, en recreate them afterwards, then everything is ok.
Problem is, due to the size of the table, and the time window, this is not an option to do every load...
Does anyone recognizes this problem?
Anyone an idea what is causing the indexes to become corrupt?
Does anyone has any idea how to fix this?
Is the cause related to the partitioning, and the indexes being on other columns than the partitioned index?
Would removing the partitiong be any help (I'd like to have any clues before I do all the work)?
Any help at all would be greatly appreciated !!!
June 25, 2012 at 10:30 am
So the table is a heap (no clustered index), there are no unique constraints whatsoever, yet you get an error inserting a duplicate row...Can you please post the exact DDL for the table and for each non-clustered index?
If your table has no constraints and your SSIS package is performing UPDATES, how are you determining which row gets updated if you don't have a primary key/unique identifier?
Also, you could just drop the problematic index (not the other two) and recreate that one after the ETL load completes...
Is the cause related to the partitioning, and the indexes being on other columns than the partitioned index?
I believe this could be your culprit!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 25, 2012 at 10:33 am
I'd say the first verification test is to double-check your indexes and if they are unique:
select
name,
is_unique,
is_unique_constraint
from sys.indexes
where name in
(
'YourIndexName1',
'YourIndexName2',
'YourIndexName3'
);
June 26, 2012 at 12:51 am
Hereby my sql code to create the table (as you can see, a lot of columns, I've left out the foreign key statements, as they don't seem to be usefull for this analysis) :
CREATE TABLE FactRights (
FactRightsIdSrc int NOT NULL
, FactRightsPersonId int NOT NULL
, FactRightsRightId int NOT NULL
, FactRightsRightIdSrc char(3) NOT NULL
, FactRightsRightSourceId int NOT NULL
, FactRightsInitialCreationDate datetime2 NOT NULL
, FactRightsRightInitialStartCalendarId int NOT NULL
, FactRightsAttributionCalendarId int NOT NULL
, FactRightsBrutoCalculationCalendarId int NOT NULL
, FactRightsAttributedAmount numeric(14,2) NOT NULL
, FactRightsBrutoAmount numeric(14,2) NOT NULL
, FactRightsForeignPensionAmount numeric(14,2) NOT NULL
, FactRightsPublicPensionAmount numeric(14,2) NOT NULL
, FactRightsInternationalInstitutionAmount numeric(14,2) NOT NULL
, FactRightsPaymentStatusId int NOT NULL
, FactRightsNonPaymentReasonId int NOT NULL
, FactRightsMinimumPaidId int NOT NULL
, FactRightsGrantedMinimumTypeId int NOT NULL
, FactRightsExtinctByCalculationRule char(1) NOT NULL
, FactRightsCareerNumerator numeric(4,2) NOT NULL
, FactRightsCareerDenominator numeric(2,0) NOT NULL
, FactRightsRVPmandateMentionesRSVZdata char(1) NOT NULL
, FactRightsRSVZmandateMentionesRVPdata char(1) NOT NULL
, FactRightsEmploymentFTDaysEquivalent numeric(5,0) NOT NULL
, FactRightsNrYearsApplicableForMinRevenue numeric(2,0) NOT NULL
, FactRightsNrYearsNotApplicableForMinRevenue numeric(2,0) NOT NULL
, FactRightsFirstYearAllowedVGPV char(1) NOT NULL
, FactRightsAmountSubrogatedToPublicPension numeric(14,2) NOT NULL
, FactRightsCareerYearsSubrogatedToPublicPension numeric(4,2) NOT NULL
, FactRightsSubrogatedToPublicPensionCalendarId int NOT NULL
, FactRights_CB_ComplementAmount numeric(14,2) NOT NULL
, FactRights_CB_TotalAttributedAmount numeric(14,2) NOT NULL
, FactRights_CB_TotalBrutoAmount numeric(14,2) NOT NULL
, FactRights_CB_MinimumPaidId int NOT NULL
, FactRights_CB_GrantedMinimumTypeId int NOT NULL
, FactRights_CB_CareerNumerator numeric(4,2) NOT NULL
, FactRights_CB_CareerDenominator numeric(2,0) NOT NULL
, FactRights_CB_EmploymentFTDaysEquivalent numeric(5,0) NOT NULL
, FactRights_CB_NrYearsApplicableForMinRevenue numeric(2,0) NOT NULL
, FactRights_CB_NrYearsNotApplicableForMinRevenue numeric(2,0) NOT NULL
, FactRights_CB_ReferenceAmountForeignPension numeric(14,2) NOT NULL
, FactRights_CB_AttributedCeilingAmount numeric(14,2) NOT NULL
, FactRights_CB_ForeignCareerNumerator numeric(7,2) NOT NULL
, FactRights_CB_ForeignCareerDenominator numeric(7,2) NOT NULL
, FactRightsAnticipationReductionPercentage numeric(3,0) NOT NULL
, FactRightsFamilyPension char(1) NOT NULL
, FactRightsRightToPBZ char(1) NOT NULL
, FactRightsDeceasedPartnerPersonId int NOT NULL
, FactRightsSurvivalInitialCalendarId int NOT NULL
, FactRightsSurvivalTypeId int NOT NULL
, FactRightsReasonBefore45Id int NOT NULL
, FactRightsNumberOfWidows numeric(2,0) NOT NULL
, FactRightsAttributedCeilingAmount numeric(14,2) NOT NULL
, FactRightsForeignCareerNumerator numeric(7,2) NOT NULL
, FactRightsForeignCareerDenominator numeric(7,2) NOT NULL
, FactRightsPublicCareerNumerator numeric(7,2) NOT NULL
, FactRightsPublicCareerDenominator numeric(7,2) NOT NULL
, FactRightsInternationalInstitutionCareerNumerator numeric(7,2) NOT NULL
, FactRightsInternationalInstitutionCareerDenominator numeric(7,2) NOT NULL
, FactRightsDeductedSurvivalPensions numeric(2,0) NOT NULL
, FactRightsTemporaryLimitedCumul char(1) NOT NULL
, FactRightsRSVZcareerNumerator numeric(7,2) NOT NULL
, FactRightsRSVZcareerDenominator numeric(7,2) NOT NULL
, FactRightsRaisedBasicAmount char(1) NOT NULL
, FactRightsExemptionTypeId int NOT NULL
, FactRightsChildBenefit varchar(20) NOT NULL
, FactRightsNumberOfCohabitants numeric(3,0) NOT NULL
, FactRightsBaseAmountTypeId int NOT NULL
, FactRightsCommunityMember char(1) NOT NULL
, FactRightsTotalIncomeAmount numeric(14,2) NOT NULL
, FactRightsTemporaryAlternativeCalculation char(1) NOT NULL
, FactRightsAmountPaidToThirdParty numeric(14,2) NOT NULL
, FactRightsStayInResthome char(1) NOT NULL
, FactRightsHandicapPercentage numeric(3,0) NOT NULL
, FactRightsBonusDays int NOT NULL
, FactRightsDerivedFromRightId int NOT NULL
, FactRightsMonthsPayable numeric(3,0) NOT NULL
, FactRightsComplementAmount numeric(14,2) NOT NULL
, FactRights_FS_BrutoAmount numeric(14,2) NOT NULL
, FactRights_FS_BrutoCalculationCalendarId int NOT NULL
, FactRights_FS_PaymentStatusId int NOT NULL
, FactRights_FS_AttributedFamilyAmount numeric(14,2) NOT NULL
, FactRights_FS_ComplementAmount numeric(14,2) NOT NULL
, FactRights_FI_ForeignInfluenceTypeId int NOT NULL
, FactRights_FI_ForeignRegulationId int NOT NULL
, FactRights_FI_AttributedAmountTheoretical numeric(14,2) NOT NULL
, FactRights_FI_CareerNumeratorTheoretical numeric(4,2) NOT NULL
, FactRights_FI_CareerDenominatorTheoretical numeric(2,0) NOT NULL
, FactRights_FI_AttributedAmountProrata numeric(14,2) NOT NULL
, FactRights_FI_CareerNumeratorProrata numeric(7,2) NOT NULL
, FactRights_FI_CareerDenominatorProrata numeric(7,2) NOT NULL
, FactRights_FI_EmploymentFTDaysEquivalent numeric(5,0) NOT NULL
, FactRights_FI_MinimumPaidId int NOT NULL
, FactRights_FI_GrantedMinimumTypeId int NOT NULL
, FactRights_FI_NrYearsApplicableForMinRevenue numeric(2,0) NOT NULL
, FactRights_FI_NrYearsNotApplicableForMinRevenue numeric(2,0) NOT NULL
, FactRights_FI_AttributedCeilingAmount numeric(14,2) NOT NULL
, ValidFrom datetime2 NOT NULL
, ValidTo datetime2 NOT NULL
, MostRecent char(1) NOT NULL
, InsertLoadNumber int NOT NULL
, UpdateLoadNumber int NULL
, DeleteLoadNumber int NULL
, Deleted char(1) NOT NULL
, SourceSystem varchar(20) NOT NULL
) ON [PSCH_FactRights_RightIdSrc](FactRightsRightIdSrc) -- partitioning
and hereby the sql code to create the indexes, pretty simple I think:
CREATE NONCLUSTERED INDEX IDX_NC_NU_FactRights_MostRecent ON FactRights(MostRecent)
CREATE NONCLUSTERED INDEX IDX_NC_NU_FactRights_PersonId ON FactRights(FactRightsPersonId)
CREATE NONCLUSTERED INDEX IDX_NC_NU_FactRights_RightsIdSrc ON FactRights(FactRightsIdSrc)
To derive that it is a new record or an existing one, which could need an (historical) update, is done by the combination of the fields FactRightsIdSrc and MostRecent.
FactRightsIdSrc is the key in the source table, MostRecent is used beacuse this datawarehouse table contains historical updates.
I do the full logic in SSIS, with the combination of LookUp and ConditionalSplit components. It was a lot of writing, but is certainly a better way than using the built-in SCD component (which doesn't work that performant, not to mention the fact that you need to remap everything every time you re-open the component).
Dropping the index which is causing the problem, has been done, but then it is another index which causes the error.
So only possibility is to drop all indexes before the ETL, and to recreate them after the ETL has done the necessary work.
Of course, without the indexes, loading this table via SSIS takes 2h, with the indexes 20 minutes.
So indexes do not only boost the performance of our reports, but also performance of our ETL...
If the partitioning is causing all this issues, I could recreate the table without any partitioning, I am certainly willing to try this.
But it would be nice to know why the partitioning is causing this issues, it doesn't seem logical to me...
@thomas, I have checked everything, and I am pretty sure that the indexes are non-unique (hence the statements above).
Any further help is still greatly appreciated !
Tom
June 26, 2012 at 1:31 am
Maybe an interesting fact too: everything worked fine for about 1 à 2 weeks, but then, suddenly out of nowhere, without any changes to the table, the error appeared.
My colleague states that maybe it has to do something with sql server statistics or something (I don't realy know this, and we aren't doing anything manual on this neither) ?
I don't know if it's relevant, but the fact that it worked for some time, then suddenly stopped working, is strange behavior in my oppinion...
June 26, 2012 at 10:42 am
I created a simple test and never ran into any issues (however this omits the table partition). Can you script out your partition so I can see which how you set it up? There's lots of choices when you do that so I can't really guess on that one...
Simple Test:
CREATE TABLE FactRights (
FactRightsIdSrc int NOT NULL
, FactRightsPersonId int NOT NULL
, MostRecent char(1) NOT NULL
)
CREATE NONCLUSTERED INDEX IDX_NC_NU_FactRights_MostRecent ON FactRights(MostRecent)
CREATE NONCLUSTERED INDEX IDX_NC_NU_FactRights_PersonId ON FactRights(FactRightsPersonId)
CREATE NONCLUSTERED INDEX IDX_NC_NU_FactRights_RightsIdSrc ON FactRights(FactRightsIdSrc)
INSERT INTO FactRights (FactRightsIdSrc, FactRightsPersonId, MostRecent)
SELECT 1, 1, 'N'
UNION ALL SELECT 1, 2, 'N'
UNION ALL SELECT 1, 3, 'Y'
UNION ALL SELECT 2, 1, 'N'
UNION ALL SELECT 2, 2, 'Y'
UNION ALL SELECT 2, 3, 'N'
UNION ALL SELECT 3, 1, 'Y'
UNION ALL SELECT 3, 2, 'Y'
UNION ALL SELECT 3, 3, 'Y'
UNION ALL SELECT 3, 3, 'Y'
SELECT * FROM FactRights
DROP TABLE FactRights
1 1 N
1 2 N
1 3 Y
2 1 N
2 2 Y
2 3 N
3 1 Y
3 2 Y
3 3 Y
3 3 Y
Dropping the index which is causing the problem, has been done, but then it is another index which causes the error.
So only possibility is to drop all indexes before the ETL, and to recreate them after the ETL has done the necessary work.
Of course, without the indexes, loading this table via SSIS takes 2h, with the indexes 20 minutes.
So indexes do not only boost the performance of our reports, but also performance of our ETL...
I must be missing something here...if you aren't creating the indexes after the ETL is complete, don't you at least REORGANZIE/REBUILD the indexes? If you are loading a large amount of data each time the ETL runs, you will have considerable fragmentation in this table...making your reports "less efficient"
I don't believe the issue you are experiencing has anything to do with the statistics, but there's not much harm in running UPDATE STATISTICS dbo.FactRights WITH FULLSCAN/RESAMPLE
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 26, 2012 at 11:35 am
There's something missing... You have to have some kind of constraint somewhere, i.e. FK, CONSTRAINT... Something is missing from the DDL you gave us. Can you check again? Not just indexes, but all objects on that table.
Jared
CE - Microsoft
June 26, 2012 at 12:26 pm
Basic question, maybe nothing, but you gave us the generic error message:
"...Cannot insert duplicate key row in object 'TableName' with unique index 'IndexName'..."
Do the TableName and IndexName pertain to the table for which you provided DDL? The question is leading. Are there any triggers on your table that may be trying to insert rows into another table where a unique index resides?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2012 at 12:59 pm
Did u recently migrated the DB from SQL server 2008 to SQL server 2008 R2? If yes then try dropping and recreating the table.
I had the similar issue... with a table containing 1.2 Billion Records. I dropped and recreated the table. This resolved the issue and working for last 6 months.
Hope this helps.
Cheers,
Viral
June 27, 2012 at 12:23 am
Thanks for all the replies yet, I'm glad to see that people are willing to help me on this strange one 🙂
DDL: the DDL I provided is correct, there is nothing missing in it, except for the FK statements to other tables.
Indexes:
- I don't rebuild indexes, since our daily ETL will insert and update in total for about 5000 to 10.000 records.
Since the table contains more than 10 million of records, the cost of rebuilding indexes after each etl is very high...
- Th error I get is referencing this table, and then the index name which is causing the problem. When I drop that index, the next day it will provide an error on the next index, and so on, until all indexes are dropped.
Jessie's test: we have lots of tables with few data, few columns and indexes, where we don't get any error at all. This is the first time we get this situation, I'm gessing it has something to do with the combination of partitioning and many columns. We have another partitioned fact table, with about 10 nonclustered nonunique indexes, with more than 150 million of records, where we don't have the problem. But that table only has for about 20 columns...
Triggers: we don't have any trigger on our complete database. We haven't got any need so far, and we always try to find another solution then triggers, so that can't be the problem.
Migration: since the beginning, we are in 2008 r2, so no migration has been done...
June 27, 2012 at 12:24 am
Here is the complete syntax for the partitioning on this FactRights table :
-- FileGroups
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_001;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_002;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_003;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_004;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_005;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_006;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_007;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_008;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_009;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_010;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_011;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_012;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_013;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_014;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_015;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_016;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_017;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_018;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_019;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_020;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_021;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_022;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_023;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_024;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_025;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_026;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_027;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_028;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_029;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_030;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_031;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_032;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_033;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_034;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_035;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_036;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_037;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_038;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_039;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_040;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_041;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_042;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_043;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_044;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_045;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_046;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_047;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_048;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_049;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_050;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_051;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_052;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_053;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_054;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_055;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_056;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_057;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_058;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_059;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_060;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_061;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_062;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_063;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_064;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_065;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_066;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_067;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_068;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_069;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_070;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_071;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_072;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_073;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_074;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_075;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_076;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_077;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_078;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_079;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_080;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_081;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_082;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_083;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_084;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_085;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_086;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_087;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_088;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_089;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_090;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_091;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_092;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_093;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_094;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_095;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_096;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_097;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_098;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_099;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_100;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_101;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_102;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_103;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_104;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_105;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_106;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_107;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_108;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_109;
ALTER DATABASE DWH_PENSION ADD FILEGROUP FG_FactRights_Other;
-- Files
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_001', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_001.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_001;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_002', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_002.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_002;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_003', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_003.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_003;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_004', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_004.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_004;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_005', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_005.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_005;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_006', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_006.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_006;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_007', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_007.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_007;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_008', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_008.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_008;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_009', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_009.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_009;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_010', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_010.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_010;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_011', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_011.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_011;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_012', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_012.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_012;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_013', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_013.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_013;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_014', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_014.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_014;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_015', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_015.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_015;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_016', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_016.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_016;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_017', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_017.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_017;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_018', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_018.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_018;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_019', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_019.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_019;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_020', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_020.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_020;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_021', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_021.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_021;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_022', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_022.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_022;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_023', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_023.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_023;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_024', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_024.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_024;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_025', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_025.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_025;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_026', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_026.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_026;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_027', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_027.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_027;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_028', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_028.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_028;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_029', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_029.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_029;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_030', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_030.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_030;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_031', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_031.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_031;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_032', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_032.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_032;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_033', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_033.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_033;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_034', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_034.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_034;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_035', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_035.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_035;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_036', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_036.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_036;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_037', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_037.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_037;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_038', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_038.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_038;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_039', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_039.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_039;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_040', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_040.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_040;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_041', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_041.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_041;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_042', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_042.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_042;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_043', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_043.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_043;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_044', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_044.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_044;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_045', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_045.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_045;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_046', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_046.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_046;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_047', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_047.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_047;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_048', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_048.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_048;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_049', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_049.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_049;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_050', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_050.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_050;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_051', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_051.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_051;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_052', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_052.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_052;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_053', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_053.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_053;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_054', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_054.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_054;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_055', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_055.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_055;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_056', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_056.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_056;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_057', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_057.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_057;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_058', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_058.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_058;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_059', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_059.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_059;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_060', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_060.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_060;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_061', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_061.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_061;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_062', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_062.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_062;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_063', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_063.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_063;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_064', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_064.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_064;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_065', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_065.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_065;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_066', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_066.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_066;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_067', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_067.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_067;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_068', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_068.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_068;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_069', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_069.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_069;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_070', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_070.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_070;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_071', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_071.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_071;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_072', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_072.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_072;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_073', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_073.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_073;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_074', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_074.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_074;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_075', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_075.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_075;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_076', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_076.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_076;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_077', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_077.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_077;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_078', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_078.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_078;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_079', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_079.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_079;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_080', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_080.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_080;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_081', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_081.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_081;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_082', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_082.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_082;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_083', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_083.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_083;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_084', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_084.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_084;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_085', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_085.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_085;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_086', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_086.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_086;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_087', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_087.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_087;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_088', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_088.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_088;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_089', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_089.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_089;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_090', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_090.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_090;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_091', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_091.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_091;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_092', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_092.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_092;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_093', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_093.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_093;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_094', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_094.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_094;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_095', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_095.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_095;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_096', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_096.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_096;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_097', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_097.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_097;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_098', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_098.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_098;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_099', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_099.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_099;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_100', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_100.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_100;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_101', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_101.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_101;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_102', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_102.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_102;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_103', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_103.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_103;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_104', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_104.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_104;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_105', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_105.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_105;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_106', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_106.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_106;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_107', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_107.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_107;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_108', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_108.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_108;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_109', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_109.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_109;
ALTER DATABASE DWH_PENSION ADD FILE (NAME = N'FG_FactRights_Other', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\DWH_PENSION\FG_FactRights_Other.ndf', SIZE = 1MB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%) TO FILEGROUP FG_FactRights_Other;
-- Partition Function
CREATE PARTITION FUNCTION [PFCT_FactRights_RightIdSrc](char(3))
AS RANGE LEFT FOR VALUES
('001','002','003','004','005','006','007','008','009','010','011','012','013','014','015','016','017','018','019','020','021','022','023','024','025',
'026','027','028','029','030','031','032','033','034','035','036','037','038','039','040','041','042','043','044','045','046','047','048','049','050',
'051','052','053','054','055','056','057','058','059','060','061','062','063','064','065','066','067','068','069','070','071','072','073','074','075',
'076','077','078','079','080','081','082','083','084','085','086','087','088','089','090','091','092','093','094','095','096','097','098','099','100',
'101','102','103','104','105','106','107','108','109')
GO
-- Partition Scheme
CREATE PARTITION SCHEME [PSCH_FactRights_RightIdSrc]
AS PARTITION [PFCT_FactRights_RightIdSrc]
TO
([FG_FactRights_001],[FG_FactRights_002],[FG_FactRights_003],[FG_FactRights_004],[FG_FactRights_005],
[FG_FactRights_006],[FG_FactRights_007],[FG_FactRights_008],[FG_FactRights_009],[FG_FactRights_010],
[FG_FactRights_011],[FG_FactRights_012],[FG_FactRights_013],[FG_FactRights_014],[FG_FactRights_015],
[FG_FactRights_016],[FG_FactRights_017],[FG_FactRights_018],[FG_FactRights_019],[FG_FactRights_020],
[FG_FactRights_021],[FG_FactRights_022],[FG_FactRights_023],[FG_FactRights_024],[FG_FactRights_025],
[FG_FactRights_026],[FG_FactRights_027],[FG_FactRights_028],[FG_FactRights_029],[FG_FactRights_030],
[FG_FactRights_031],[FG_FactRights_032],[FG_FactRights_033],[FG_FactRights_034],[FG_FactRights_035],
[FG_FactRights_036],[FG_FactRights_037],[FG_FactRights_038],[FG_FactRights_039],[FG_FactRights_040],
[FG_FactRights_041],[FG_FactRights_042],[FG_FactRights_043],[FG_FactRights_044],[FG_FactRights_045],
[FG_FactRights_046],[FG_FactRights_047],[FG_FactRights_048],[FG_FactRights_049],[FG_FactRights_050],
[FG_FactRights_051],[FG_FactRights_052],[FG_FactRights_053],[FG_FactRights_054],[FG_FactRights_055],
[FG_FactRights_056],[FG_FactRights_057],[FG_FactRights_058],[FG_FactRights_059],[FG_FactRights_060],
[FG_FactRights_061],[FG_FactRights_062],[FG_FactRights_063],[FG_FactRights_064],[FG_FactRights_065],
[FG_FactRights_066],[FG_FactRights_067],[FG_FactRights_068],[FG_FactRights_069],[FG_FactRights_070],
[FG_FactRights_071],[FG_FactRights_072],[FG_FactRights_073],[FG_FactRights_074],[FG_FactRights_075],
[FG_FactRights_076],[FG_FactRights_077],[FG_FactRights_078],[FG_FactRights_079],[FG_FactRights_080],
[FG_FactRights_081],[FG_FactRights_082],[FG_FactRights_083],[FG_FactRights_084],[FG_FactRights_085],
[FG_FactRights_086],[FG_FactRights_087],[FG_FactRights_088],[FG_FactRights_089],[FG_FactRights_090],
[FG_FactRights_091],[FG_FactRights_092],[FG_FactRights_093],[FG_FactRights_094],[FG_FactRights_095],
[FG_FactRights_096],[FG_FactRights_097],[FG_FactRights_098],[FG_FactRights_099],[FG_FactRights_100],
[FG_FactRights_101],[FG_FactRights_102],[FG_FactRights_103],[FG_FactRights_104],[FG_FactRights_105],
[FG_FactRights_106],[FG_FactRights_107],[FG_FactRights_108],[FG_FactRights_109],
[FG_FactRights_Other])
GO
July 9, 2012 at 1:26 am
Since there are no new messages, may I conclude that no-one can find an answer for this very annoying problem ?
If there is anyone who has any ideas, or who can help me out on this one, it would be very appreciated...
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply