Technical Article

Smart data archiving stored procedure

This stored procedure uses a series of input parametes to generate, and optionally execute a series of SQL commands to move production data to an archive table.  The procedure assumes that the production and archive tables will have the same structure.  The procedure uses the following input parameters:@SourceTable:  This is the name of the table […]

2007-09-05 (first published: )

2,660 reads

Blogs

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

SharePoint List only returns 100 items in Azure Logic App

By

I was reading a SharePoint List using the “Get Items” activity in an Azure...

Daily Coping 27 Jun 2022

By

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

Read the latest Blogs

Forums

Database backup and restore

By DBA

Hello, I've a user database which I want to migrate to new server, so...

Help Implementing Sample SQL Code

By carlton 84646

Hi community, I am trying to implement sample sql code: SELECT [LocalizedLabel] as [<COLUMN_NAME>]...

Error restore database in AZURE

By abdalah.mehdoini

Hello everyone, I created my SQL server Azure in PASS when i try to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers