Re: The size of the DB

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/30/03 

Date: Fri, 29 Aug 2003 18:25:02 -0400

Well your db size is the sum of all the files. You can check out sysfiles
in the master db for the size of those. 

-- 
Andrew J. Kelly
SQL Server MVP
"Jose Martinez" <jomapa01@hotmail.com> wrote in message
news:030001c36e78$990c5900$a601280a@phx.gbl...
> Hi:
>
> Could any one tell me in wich system table (sysobjects,
> sysnames, etc) is stored the actual size of the Data Bases
>
> Regards

Relevant Pages

  • Re: How to use Seek vs FindFirst
    ... My query calculates a sum for each type of record in another table ... I have a master table I want to update with these sums. ... Case 1-- using seek, edit and update ... I know I could do this by using a query or two, ...
    (microsoft.public.access.formscoding)
  • Re: Sub Project Titles Do Not Update in Master and Vice Versa
    ... You're welcome, Andrew :-) ... See http://tinyurl.com/2xbhc for my free Project Tutorials ... You have to understand that a Master file only holds placemarkers ... to File-Properties and change the Title of the sub-project while I ...
    (microsoft.public.project)
  • Re: Find Duplicates in one column and sum other column
    ... I would import multiple files of excel into one master table in access. ... If case ID,Name & Activity is similar in two or more records then I need to merge all of those records into one record with the sum of time taken. ... Idea is if an employee has worked on the same activity & same case twice or "n" times then i need to grab the total time in the table. ... I can so this on excel using concatenate & sumif function, please help me do this in access. ...
    (microsoft.public.access.modulesdaovba)
  • Re: After Restore of a DB to another, it runs slower?
    ... Well running it in Master does nothing for the stats in the user db. ... Andrew J. Kelly SQL MVP "Deke" wrote in message ... > Well I ran the sp_udatestats from the master db in query analyzer and it> showed a bunch of stuff being updated, but when I run the query it's still ...
    (microsoft.public.sqlserver.server)
  • Re: Find Duplicates in one column and sum other column
    ... Create a report and use Grouping and Sorting of the records and Sum the Time ... Taken field in report footer. ... I have a master table with Five columns. ... I can so this on excel using concatenate & sumif function, ...
    (microsoft.public.access.modulesdaovba)