Scripts

Script to Attach Multiple MDF

Copies mdf files located in a directory on a client and attaches them to the connected server. This is the winning solution to the contest that was presented in an article posted at http://www.sqlservercentral.com/columnists/awarren/reattachingdatabases-somecodeandacontest!.asp. That article shows how to do the same thing using DMO. Wynn Muse is the author of this stored procedure.

2001-09-23

2,537 reads

Trim Backup Files

This script runs within a DTS package. It searches the backup directory stored as a global variable in the script and trims all backup files older than some number of days. the script includes logging to the C: drive so you can trace the effects of the script. You need to create the global variables […]

1 (1)

2001-09-12

1,460 reads

Automatic Backups

Creates the backup devices where sql server is installed, creates an error message above 50001, an alert, and an adittional job in case the scripts fails. In the first time backups all databases and then backups the logs until two days past from the last full backup. Then backups the databases again and so on. […]

2 (1)

2001-09-07

1,178 reads

Blogs

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Read the latest Blogs

Forums

Insert in batches using select coalesce option

By vamshi.sql

Hi, I am trying to insert multiple tables data into one table using Insert...

Fastest Way to Calculate Total Number of records inserted per day

By bhavi

Hi, I need to show a number of records per day in the dashboard...

Fastest way to query Millions of records with Pagination and Total Record Count

By bhavi

HI, We had a table that contains a huge volume of data inserted per...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers