Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 altering a table size

Author  Topic 

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2010-11-12 : 12:26:42
hi every body.is there any way to alter the size of a table.i mean to increase or decrease the size of a table.thanx in advance.

X002548
Not Just a Number

15586 Posts

Posted - 2010-11-12 : 12:40:45
Is this a SQL Server Database question?

You would need to set up a filegroup specifically for that table...but to what end?

What are you trying to accomplish?

Is this a SQL Server Database question?


Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

mmarovic
Aged Yak Warrior

518 Posts

Posted - 2010-11-13 : 13:43:18
What do you mean by "size of a table"? Number of rows, space its data occupies in database? Maybe you wanted to increase or decrease the size of database or database files?
Go to Top of Page

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2010-11-14 : 00:25:14
it is a sql server database question.when u run 'msforeachdatabase' stored proc int the result set u get a column with the name 'reserved size'.my question is can we change that reserved size of the table.
Go to Top of Page
   

- Advertisement -