Creating Backup Devices
This Stored Procedure create backup devices for all user databases. You can customize path, name standard and type of device.See Creating Job Backup
2002-09-12
515 reads
Creating Job Backup
This Stored Procedure create backup job for all user databases. You can customize SQLAdmin operator.See Creating Backup Devices
2002-09-12
839 reads
Blogs
Goal Progress–Feb 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
How to: exec sp_help on temp tables?
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
Daily Coping 26 Feb 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Better query to get count based on column value
I am using SQL server 2008 R2 express edition. Out of below 3 method...
Why are DBAs not paid for knowledge and other IT Professionals are?
DBAs are being asked to know everything for 6 figures which cap out for...
Common Table Expression Misunderstandings
Comments posted to this topic are about the item Common Table Expression Misunderstandings
Ask SSC