Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 system databases

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-06-18 : 12:09:03
Hi,
How do I check he data file size, transaction log size and autogrowth setting of each of the system databases please?
I am not sure if sp_helpdb works for these?

Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-06-19 : 03:15:33
sp_helpdb works just fine for the system databases. It returns the same information as it does for user databases

--
Gail Shaw
Go to Top of Page
   

- Advertisement -