sqlserver 增加数据库空间

use master 

go

create procedure _dba_add_db_space

as

begin

declare @db_size int

declare @strSQL VARCHAR(500)

select @db_size = convert(float,size) * (8192.0/1024.0) from Gateway_yd.[dbo].[sysfiles] where fileid = 1

if @db_size < 307200

begin

set @db_size += 512000

--print @db_size

set @strSQL = 'ALTER DATABASE Gateway_yd MODIFY FILE ( NAME = N''Gateway_yd'', SIZE = '+ CAST( @db_size as varchar) + ' KB )'

--print @strSQL

exec(@strSQL)

end

 

--select name, convert(float,size) * (8192.0/1024.0)from Gateway_yd.dbo.sysfiles

--select name, size from Gateway_yd.dbo.sysfiles

 

--use Gateway_yd

--Exec sp_spaceused

end