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

[PowerShell Newbie] Using Start-Transcript

By

This week we are going to launch a blog series geared towards folks that...

My Experience on Geeks on Screen with Coffee

By

Last week on appeared on Geeks on Screen with Coffee which broadcast on YouTube...

Captioning Options for Your Online Conference

By

Many conferences have moved online this year due to the pandemic, and many attendees...

Read the latest Blogs

Forums

Event Notifications - Can these be set up to monitor for changes to table data?

By tarr94

Hello, I'm new to using Event Notifications, but it is my understanding that they...

Variable Based on Variable in Paginated Report w/ Native Oracle Connection

By dataanalystanonymous

I have an SSRS paginated report where users need the ability to pick and...

IndicatorsPool events causing memory pressure?

By Ian (SSC)

Hi, We are running a system on SQLServer 2017 Enterprise (RTM-CU22) with 839GB of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers