This script was written to solve a problem where we needed to dynamically create bch files for Veritas Backups direct to tape backups. We needed to parse the sysdatabases daily and create the bch files that veritas would use to backup each server and database. This SQL Script uses xp_cmdshell to call a windows shell […]
2007-10-02 (first published: 2007-06-18)
420 reads
By Arun Sirpal
Just a really quick FYI for the readers. If you are using Managed Instances...
It has been some time since I last wrote about Azure SQL Database. Although...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
am trying to avoid using while loop but OK with it... We are talking...
I am trying to avoid using while loop but OK with it... We are...
Do I still need to run sp_updatestats if I execute DBCC DBREINDEX(tablename) for tables...
Ask SSC