|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
size of a tabledear all,
I'm looking for a system stored procedure which return me the total size of a specific table. I don't remember at all. regards, EXEC sp_spaceused 'tablename';
Show quoteHide quote "Enric" <En***@discussions.microsoft.com> wrote in message news:25932623-9B70-4EFB-A247-CCD8FDAF7CB4@microsoft.com... > dear all, > > I'm looking for a system stored procedure which return me the total size > of > a specific table. I don't remember at all. > regards, you were very useful
Show quoteHide quote "Aaron Bertrand [SQL Server MVP]" wrote: > EXEC sp_spaceused 'tablename'; > > > "Enric" <En***@discussions.microsoft.com> wrote in message > news:25932623-9B70-4EFB-A247-CCD8FDAF7CB4@microsoft.com... > > dear all, > > > > I'm looking for a system stored procedure which return me the total size > > of > > a specific table. I don't remember at all. > > regards, > > >  
Other interesting topics
Using FKs to non PK unique-indexes
1 to many relationship between columns dynmica use @db sql Help trouble using a temp table in another SELECT SELECT info from table on a different server Get the top 2 sold without using temp table. Help importing legacy FoxPro db into SQL 2000 Executing Stored Procedure within Trigger Difference Function |
|||||||||||||||||||||||
