Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

GetFileInfo2

By Jeff Weisbecker,

An Improved version of GetFileInfo that now includes the space utilization of each datafile.  Provides more detail per file.  Predict when your files are going to grow!! Both data and log files. This script organizes information about the database files on the server.   A cursor is used to get the information from each database.  The information is reported in Megabytes, including the next allocation from disk.   No bells and whistles



Total article views: 509 | Views in the last 30 days: 1
 
Related Articles
FORUM

replication information

replication information

FORUM

Hardware Information

Hardware Information

FORUM

Information about reports ran

Information about reports ran

FORUM

information of deleted job

information of deleted job

FORUM

Sql Server Information

Gathering Server information

Tags
 
Contribute