Technical Article

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

271 reads

Technical Article

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,179 reads

Technical Article

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

388 reads

Technical Article

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,035 reads

Blogs

Goal Progress for Jan 2023

By

The grade for January is a D. Details below, but just not making a...

Context Info Across Databases–#SQLNewBlogger

By

Does Context Info work across databases? This post shows it does. Another post for...

Introducing… Data On Rails!

By

Data On Rails is a Data On Wheels project designed to give a platform...

Read the latest Blogs

Forums

Identity column and "EntityID" column naming convention

By CreateIndexNonclustered

This isn't* specific to 2022, but SQL in general. I will be joining a...

Replace Primary Server keeping same Log Shipping Server

By BobAtDBS

I have a two node SQL Standard 2014 Failover Cluster at the primary site. ...

Memory Issue With A SQL Server Express 2019 Server Database Application

By Rob Reid-246754

Hi, I have just moved a DB from an old HP laptop, to a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers