Monitor Database and Log Growth

• Lori B

  Ten Centuries

  Points: 1149

  More actions

  October 13, 2007 at 6:19 pm

  #182870

  Comments posted to this topic are about the item Monitor Database and Log Growth

• René Oertel

  Newbie

  Points: 5

  More actions

  April 20, 2020 at 12:05 pm

  #3744600

  I want to run this script on the server itself. I don't have a SQL Server for administrative purposes. Can I adapt this script for this purpose or is this not recommended?

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  April 20, 2020 at 2:05 pm

  #3744645

  René Oertel wrote:

  I want to run this script on the server itself. I don't have a SQL Server for administrative purposes. Can I adapt this script for this purpose or is this not recommended?

  To be honest, if you don't have the access on a server to do this, then you probably don't have a good reason to do this because you're not the DBA.

  That being said, if you're not the DBA, why would you need to do this?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)