table size

[nowayout]

Hi all,

Need to check what the table size after the data transfer. How can i change is and how can i increase the size of it!!

thanks

 

[mrdenny]

The table will increase in size automatically. You can check in EM by switching the view from icons to task pad. Right click on the database, select view then taskpad. Go to the tables tab.

On you can use sp_spaceused like this.

sp_spaceused '{table_name}'

Denny

--Anything is possible. All it takes is a little research. (Me)