Here's another one.

CREATE PROCEDURE sp_diskspace

AS

/*

   Displays the free space,free space percentage

   plus total drive size for a server

*/

SET NOCOUNT ON

DECLARE @hr int

DECLARE @fso int

DECLARE @drive char(1)

DECLARE @odrive int

DECLARE...

Hi,

I'd like a gmail invite.

Thanks for the offer.

Have a great day,

Steve Morrow

smorrow@hickorytech.net

My database is about 120 GIG.

How often would you suggest running sp_updatestats?

Thanks for your help.

Steven R. Morrow

Thanks for the tip.

Do you know if it will take Site specific commands like the following?

site lrecl=750 recfm=fb blksize=27750 unit=prod cylinders primary=5

secondary=5

Have a nice day,

Steve

Steven R. Morrow