[易飞]一、邮件预警-检测服务器存储过程

 本序列文章完全原创如果转载请注明，谢谢！

--==================================================
--用途：查看服务器的硬盘余额
--作者: 龚德辉
--日期：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