available space in table?

sp_spaceused is what you need to use

USE [AdventureWorks]
GO

[sys].[sp_spaceused] @objname = N'humanresources.shift'
go
INSERT [HumanResources].[Shift]
       ( [ShiftID] ,
         [Name] ,
         [StartTime] ,
         [EndTime] ,
         [ModifiedDate]
       )
VALUES  ( 0 , -- ShiftID - tinyint
         N'' , -- Name - nvarchar(50)
         '2012-04-08 16:57:41' , -- StartTime - datetime
         '2012-04-08 16:57:41' , -- EndTime - datetime
         '2012-04-08 16:57:41'  -- ModifiedDate - datetime
       )
GO 2000


[sys].[sp_spaceused] @objname = N'humanresources.shift', @updateusage='true'

will show how the space used by a table changes when rows are inserted

before:

name    rows   reserved    data  index_size   unused
Shift   203     72 KB     8 KB    8 KB       56 KB

after:

name    rows   reserved    data  index_size   unused
Shift   2203    136 KB        80 KB  8 KB     48 KB

Not sure that I quite understand - tables are not limited in any particular way, beyond those limits of the database storage engine itself. If you're interested in the limits that do affect SQL Server, I would suggest you start here: http://msdn.microsoft.com/en-us/library/ms143432.aspx

If you want to know how much space a table is using, I suggest having a look at how to run sp_spaceused - http://msdn.microsoft.com/en-us/library/ms188776.aspx

No, I don't believe so.

The amount of available space for an individual table would be the available space that is in the database, furthermore, if the database is set to unrestricted growth, then the table would be free to grow until the database consumed all available disk on the hard drive.

Hope this helps!

is possible to free the space? was made a shrink on the files and release only 2GB what else can we do?

Space Reserved : 46.49GB Space Used : 20.26GB

Total Sapace Usage: 48739.13MB Data files Space usage: 47602.00MB Transaction Log Space usage: 11911.13MB