本序列文章完全原创如果转载请注明,谢谢!--==================================================
--用途:查看服务器的硬盘余额
--作者: 龚德辉
--日期:2011-03-15
--==================================================
ALTER Procedure [dbo].[UP_GetServerSpace]
as
begin
create table ##serverspace(drive char(1),freespace varchar(12))
insert into ##serverspace exec master..xp_fixeddrives
select @@servername as 数据库服务器, drive as 驱动盘符,freespace/1024 as 剩余空间G from ##serverspace
drop table ##serverspace
end
