|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Database size entry?Which system table is the currently defined size (hopefully the total size)
of the data and log devices found? I'm assuming in master somewhere? sysobjects? I just can't find it... thanks Dave,
Check out: sysfiles HTH Jerry Show quote "Dave H" <DaveH@noemail.nospam> wrote in message news:JpydnanWHeJCj6HeRVn-ug@comcast.com... > Which system table is the currently defined size (hopefully the total > size) > of the data and log devices found? > > I'm assuming in master somewhere? sysobjects? I just can't find it... > thanks > > That's what I'm doing now.. is that how 'properties' figures the size?
lol: I totally looked past size there, and was just getting the file names... Thanks... Show quote "Jerry Spivey" <jspi***@vestas-awt.com> wrote in message news:ODlqHFRxFHA.1256@TK2MSFTNGP09.phx.gbl... > Dave, > > Check out: > > sysfiles > > HTH > > Jerry > "Dave H" <DaveH@noemail.nospam> wrote in message > news:JpydnanWHeJCj6HeRVn-ug@comcast.com... > > Which system table is the currently defined size (hopefully the total > > size) > > of the data and log devices found? > > > > I'm assuming in master somewhere? sysobjects? I just can't find it... > > thanks > > > > > > Hi,
Its been taken from sysfiles table. You could just run a prfiler and get the query. See the query I get for Master database property. SELECT o.fileid, o.name, o.filename, o.groupid, o.size, o.maxsize, o.growth, o.status FROM dbo.sysfiles o WHERE o.groupid = (SELECT u.groupid FROM dbo.sysfilegroups u WHERE u.groupname = N'PRIMARY') and (o.status & 0x40) = 0 go SELECT fileid, name, filename, size, growth, status, maxsize FROM dbo.sysfiles WHERE (status & 0x40) <> 0 Thanks Hari SQL Server MVP Show quote "Dave H" <DaveH@noemail.nospam> wrote in message news:ec-dnRXjTNF0iKHeRVn-rw@comcast.com... > That's what I'm doing now.. is that how 'properties' figures the size? > > lol: I totally looked past size there, and was just getting the file > names... > > Thanks... > > > "Jerry Spivey" <jspi***@vestas-awt.com> wrote in message > news:ODlqHFRxFHA.1256@TK2MSFTNGP09.phx.gbl... >> Dave, >> >> Check out: >> >> sysfiles >> >> HTH >> >> Jerry >> "Dave H" <DaveH@noemail.nospam> wrote in message >> news:JpydnanWHeJCj6HeRVn-ug@comcast.com... >> > Which system table is the currently defined size (hopefully the total >> > size) >> > of the data and log devices found? >> > >> > I'm assuming in master somewhere? sysobjects? I just can't find it... >> > thanks >> > >> > >> >> > >  |
|||||||||||||||||||||||
Other interesting topics