Yes,try to do that

Options => Designer = Untick 'Prevent saving changes that require table re-creation'. it will work.!!

I dont want to delete the data from the table i just want to archive into different partition since.

Here the table partition

A,B,C based on the region and then after...

Just right click on the database and take permission tab. here u can assign the user for permissions.

http://msdn.microsoft.com/en-IN/library/ms178569.aspx

Thank you..

http://blogs.msdn.com/b/menzos/archive/2008/06/30/table-partitioning-sliding-window-case.aspx

http://msdn.microsoft.com/en-us/library/aa964122%28v=sql.90%29.aspx

Based on the article from the link i hope we can do the table partition based on region into 3 partition and after a month...

Thanks for your input.

Yeah i am planning to do that way.

Region wise partitioning:

1. RegionGroup1Current,

2. RegionGroup2Current,

3. RegionGroupCurren

But here i bit confused to move the Items after one month to the another...

So the business rule is that you always archive and delete an entire region at a time. Odd, but if that's the rule then partitioning by region will help with...

Cool. In that case the business rules for how, when and by what criteria rows are archived will guide your choice of partition column.

Thank you.

I want to create 3 partitions...

Instead of moving records to a separate table. i am looking for a solution to move items into a different partition once they are old and require archiving...

planning to do the partitioning for the main table with region wise.....So that we can split the data into a different file group and the data accessible also will be...

Thanks for your suggestion....

Could you please suggest me how to do the table partitioning using number of filegroup....?

Is this a valid instance name? Is it started?

If you connect to the instance with the same administrator account, does it work?

Yes the instance is able to start with administrator...

hi All,

When i check the event viewer am getting error like

SQLServerAgent could not be started (reason: Unable to connect to server 'Node1\Inst1'; SQLServerAgent cannot start).

Yes i am using the configuration manager only for changing service account....But no luck

Hi..Thanks for your link..

But unfortunately my issue is not solved changing the Outputlog and user rights.

When i am trying to change the service user itself i am getting an unexpected...

i have given the user for administrator privilege even i tried with administrator user but no luck.