How to manage max table storage space in case of excess data

Question

I am using sql server 2008 r2  and I have created a database named testDB. I have a lot of tables with some log tables in this. some tables have contain thousands of records in log table.

So my purpose is that I want to fix the table size of those tables(log tables) and want to move records in other database table placed on another location. So my database has no problem.

Is there any way to make such above steps which I want for my database?

Is there already built any such functionality in sql server?

May be this question repeated but still I have no solution for my issue.

Thanks

Answer 1

I don't want all time tab index disabled

Answer 2

set tabindex = -1 to all control..

Answer 3

Here is how. You can define IsTabStop property to false for the other controls and it should work for you.

<Buttonx:Name="button"Content="Button"HorizontalAlignment="Left"Margin="242,107,0,0"VerticalAlignment="Top"Width="75"TabIndex="1000000"IsTabStop="False"/>
<TextBoxx:Name="textBox"HorizontalAlignment="Left"Height="23"Margin="204,67,0,0"TextWrapping="Wrap"Text="TextBox"VerticalAlignment="Top"Width="120"TabIndex="0"/>