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

Power BI Monthly Digest – October 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 26 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Read the latest Blogs

Forums

schedule a job in CMS

By mtz676

Is it possible to schedule a sql job in CMS ? As of now...

what does it mean for the following SQL Scripts

By 892717952

in a stored procedure, I found two line sql scripts "    if @@microsoftversion > 0x07320000 exec sp_MSreplraiserror 20598...

Recovering Databases From a Master Backup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Recovering Databases From a Master...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers