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.
| Author |
Topic |
|
samsun125
Yak Posting Veteran
63 Posts |
 Posted - 2008-09-29 : 09:41:53
|
| Hi all,i have one query ,in my database employee table is there , in that 400 records are there , how to check the size of the table,any body have an idea plz help me |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-09-29 : 09:42:57
|
| EXEC sp_spaceusedMadhivananFailing to plan is Planning to fail |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-09-29 : 09:56:09
|
quote:
Originally posted by samsun125
Hi all,i have one query ,in my database employee table is there , in that 400 records are there , how to check the size of the table,any body have an idea plz help me
Why did you edit the current question to a different one?EXEC sp_spaceused 'table_name'MadhivananFailing to plan is Planning to fail |
|
|
|
samsun125
Yak Posting Veteran
63 Posts |
Posted - 2008-09-29 : 10:06:59
|
| Hi MadhivananThankyou very much in this data 16kb and reserved 64kb like that i got result what is this meaningwhat i am thinking is upto 64kb we can insert the data right? for example if i want to insert 2000 records that size is exceeds the 64kb then what should i do ?? please give me idea |
|
|
|
|
|
|
how to check size of table in sql server2005?