Script to create a standby database server(new).

New feature to relocate files on the secondary server has been added to this script. If you don't need this feature please use my other script that is posted on this website.Run this script on a secondary SQL Server to replicate the data of all the user databases from the primary server every 15 minutes. […]

2002-08-09

265 reads

Script to montior ErrorLogs every 3 hours.

This script monitors your errorlogs every 3 hours for the past 3 hours. It notifies you by email for all types of errors and by pager for all critical errors with severity type > 16. Saves lot of time when you have to monitor several servers every day 24x7. Run this script on a dedicated […]

1 (1)

2002-08-09

1,172 reads

Script to create a standby database server.

This script will do a full backup and transaction log backup of all the user database on the primary server and restore it over to the secondary server. The full backup/restore runs once every day and the transaction log backup/restore runs every minutes. Just provide the name of the primary and the secondary server and […]

2002-07-12

329 reads

Concatenate Rows without a cursor

You might come accross a situation where you want to retrieve the values of all the rows concatenated and stored in one variable. Here is the solution. Lets say you have a table called tblCustomerOrders which has CustID and OrderID. You now want all the OrderIDs for a particular Customer to be stored in one […]

5 (1)

2002-07-02

1,019 reads

Blogs

Daily Coping 20 Apr 2021

By

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

The Diverse Data Platform–Dativerse.io

By

The other day I got a note from Ben Weissman the other day that...

Extended Events and Azure SQL Database

By

Knowledge of how your system behaves is vital to better control, maintain, and grow...

Read the latest Blogs

Forums

usage of BCP and BULK INSERT

By 892717952

as I'm not clear how to use bcp and bulk insert in the following...

sequence of SQL server execution plan

By 892717952

As per my understanding,  when we read the execution plan, the sql server is...

An Empty Integer Numpy Array

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Empty Integer Numpy Array

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers