Database details for Daily checks

• mssqlsrv

  SSCrazy

  Points: 2375

  More actions

  January 15, 2013 at 11:17 pm

  #266990

  Comments posted to this topic are about the item Database details for Daily checks

• aleksey donskoy

  Mr or Mrs. 500

  Points: 565

  More actions

  January 17, 2013 at 10:55 am

  #1578424

  Awesome script.

  Runs on the 90-database server for only 14 seconds giving back wealth of info.

  Two things:

  1. USE [?]; - dealing with the SharePoint databases with "-" and " " in their names

  2. database_name varchar(128) -accross the script as SharePoint database names are damn long. You could use sysname as well.

  Fixed in 2 minutes.

  Alex Donskoy

  SQL DBA

  Greenberg & Trauriq PA

  Miami , FL USA

• mssqlsrv

  SSCrazy

  Points: 2375

  More actions

  February 15, 2013 at 8:37 am

  #1588355

  Correct. I faced the same issues. Also increase the size of dbname variable.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 2, 2016 at 4:20 pm

  #1876116

  Thanks for the great script.