Can I get the available space in a perticular table? If Yes, How?
asked Apr 08 '12 at 03:07 PM in Default
sp_spaceused is what you need to use
will show how the space used by a table changes when rows are inserted
answered Apr 08 '12 at 05:04 PM
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
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!
answered Apr 08 '12 at 03:28 PM