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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Script Library
 sql growth
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Aged Yak Warrior

594 Posts

Posted - 05/06/2006 :  07:47:58  Show Profile  Send TRACEYSQL an ICQ Message  Reply with Quote
If i run this command
set ansi_warnings off

declare @l_db_name varchar(95)
,@l_sql_string varchar(2000)

set nocount on
if object_id('DB_Growth') is not null
drop table DB_Growth
--Modified filename size
create table DB_Growth (Database_Name varchar(30), Logical_File_Name varchar(35), File_Size_MB int, Growth_Factor varchar(100))

declare db_name_cursor insensitive cursor
select name from master..sysdatabases

open db_name_cursor

fetch next from db_name_cursor into

While (@@fetch_status = 0)
--ceiling((growth * 8192)/(1024.0*1024.0))
--Modified size calculation so that G size databases could be handled.
select @l_sql_string = 'select ' + '''' +@l_db_name +'''' + ', name, ceiling((CONVERT(numeric(9,2),size)* 8192/(1024.0 * 1024.0))), case when status & 0x100000 = 0 then convert(varchar,ceiling((CONVERT(numeric(9,2),grow th)* 8192/(1024.0 * 1024.0)))) + '' MB''' + char(10)+char(13)
+ 'else convert (varchar, growth) + '' Percent''' + char(10)+char(13)
+ 'end' + char(10)+char(13)
+ 'from [' + @l_db_name + '].dbo.sysfiles' --Modified database name handler so that "-" could be used

insert into DB_Growth ([Database_Name], Logical_File_Name, File_Size_MB, Growth_Factor)

exec (@l_sql_string)

fetch next from db_name_cursor into
close db_name_cursor
deallocate db_name_cursor
select * from DB_Growth with (nolock)
if object_id('DB_Growth') is not null
drop table DB_Growth
set nocount off
set ansi_warnings on

Is it true to say that if i add the mg or * by percentage to my database size i can truely say that if there was no used space that this would be the amount of hard space i need...hard space actual disk space

Is it always the 8192

  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000