SP_DBA_AUTOTRANS_DUMP_LOG

Purpose : This routine will  dump the transaction logs based on the percentage on how full the transaction logs             are  based on parmeter from the logthres table                                              […]

2003-08-01

237 reads

sp_dba_spacealert_dmo.vbs

This vbscript is used to alert and email receipients on Filegroup space usageOuput:  '% Space Avail. , Space Avail. Filesize, MaxSize, FileName, DBname, FileGroupThe process takes three arguments - SqlserverName , Threshold for percentage of available space to check ,Mininum MaxFileSize to checkExecute the script either from the command line or schedule the script via […]

2003-08-01

325 reads

Blogs

What goes around comes around : T-SQL Tuesday #129

By

I almost died. I’m sure a lot of you already know this but just...

My T-SQL Tuesday #129 Time Capsule

By

This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...

Azure Database Administrator

By

Recently I found out that I passed the BETA exam for Azure Database Administrator...

Read the latest Blogs

Forums

Change dbowner

By ramyours2003

Can we change the dbowner to system databses ? if yes how can we...

Send me an email if this job run longer than 30 minutes

By krypto69

Hi I have a job that I need to be notified/emailed if it runs...

Time out expired on the application side

By zouzou

Hi   I have an application that is timing out i run the query...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The D in ACID

See possible answers