You could use one of the templates. Here is a list and description of those templates.

http://technet.microsoft.com/en-us/library/ms190176.aspx

Sounds like the accounts were expiring.

You can checked for disabled, locked, or expired accounts using this script. You should probably monitor for this kind of thing.

SELECT sl.name,sl.is_disabled,sl.is_expiration_checked,sl.is_policy_checked,sl.modify_date

,LOGINPROPERTY(sl.name,'IsExpired') AS IsExpired,LOGINPROPERTY(sl.name,'DaysUntilExpiration')...

Here is something that will work. One significant difference is that when converting time to decimal, you usually use .25 instead of 15 increments. Based on that, here...

Here is an alternate script that provides more complete information.

http://jasonbrimhall.info/2011/11/21/table-space-cs-part-deux/

Here is an alternative that gives a bit more info.

http://jasonbrimhall.info/2011/11/21/table-space-cs-part-deux/

Here is an alternative for getting more info about table size, index size and overall size.

http://bit.ly/tablespace

Consider like read only access to dmv/system information and schema info but not the direct ability to view the data

For those interested, lowell (an ssc regular) put together quite a handy Calendar Table that can be viewed here

http://www.stormrage.com/SQLStuff/TallyCalendar_Complete_With_DST.txt

Like George said, shrinking as a 1 off is not such a bad thing.

High vlf will adversely affect restores and operations that touch the transaction log.

While instant file initialization will...

Here is an article that discusses it (running totals)

http://blog.waynesheffield.com/wayne/archive/2011/08/running-totals-in-denali-ctp3/

On a nightly basis you can run sp_cycle_errorlog (http://technet.microsoft.com/en-us/library/ms182512.aspx)

And then change the log retention to 30 days or so (or more depending on your needs).

Are you limited to SQL 2008 for this? Or do you have SQL 2012 available?

2012 has a feature that allows this kind of "quirky update" to be done using...

Here is another alternative to get the info for all databases.

CREATE TABLE #FileProp (dbid INT,FILE_ID INT, SpaceUsed DECIMAL(14,2));

GO

EXECUTE sp_MSforeachdb 'USE ?; Insert Into #FileProp (dbid,FILE_ID,SpaceUsed)

SELECT database_id,file_id,FILEPROPERTY(name,''SpaceUsed'') from sys.master_files...

Sid Childers (2/14/2014)

---

IMHO, at least 8gb RAM. 16gb is optimal,...

TheGreenShepherd (2/14/2014)

---

Yeah, I know, it's non-SARGable. That was really my last line of defense for shooting this idea down, because his next suggestion is to make that column non-nullable, and...