[font="Verdana"]

Hi

Thanks for the reply.

If you mean:

ALTER TABLE Transaction_Summary

SWITCH TO Transaction_Summary_2

ON TranactionSummary_Schema

This is not the correct syntax. Also it doesnt make sense to specify a partition number because I have...

[font="Verdana"]

Thanks. This is what I did finally, I created a table and make a PK with 2 PKs it doesnt affect the uniquness of the data the only thing is...

[font="Verdana"]

Hi

I read the article, probably I dont have a high IQ, could you please let me know what I've done wrong and what I should do?

If I knew the answer...

[font="Verdana"]

Hi

Thanks for your reply. What i didnt get is that why you created the table on one the partitions onle(FG_CHEQ) what about other partitions?just because I thought we should create...

[font="Verdana"]

Hi

I tried that one if I do below queries I'll get those error messages:

ALTER TABLE [dbo].[Transaction_Summary_2] ADD CONSTRAINT [PK_Transaction_Summary_2] PRIMARY KEY CLUSTERED

(

[Transaction_Serial_No] ASC

) ON TranactionSummary_Schema (Channel)

The error will...

[font="Verdana"]

Hi Again

I'm back again with a sea of troubles even in the last day of the year!!!

I tried to create PK without mentioning the filegroup at the end,...

[font="Verdana"]

Hi Again

What I did, I read the stuff I was recommended and I started doing it first I created the file groups and then adding the files to database and...

Thanks for the recommendation but in this case I've been told to partition on what field and I've let them know that it might be inefficient but they insist so...

So what I've done so far is not going to help me at all?