There are mainly two components. One job that is managing the full database backup - restore and a second job that manage the transaction log backup - restore. At this two a new one similar with the full database backup - restore can be added for the differential backups if is the case. I will […]
2005-02-15 (first published: 2004-04-01)
1,017 reads
It creates documentation for all user tables in a specific database. A server name/ database name was added on the top of the HTML file also a column datatype field was added to the HTML file. Now the @strHTML can have 8000 chars, before only 4000 - still for tables with a lot of columns […]
2003-10-27
632 reads
The dire warning in the subject line is not meant to scare you. Rather,...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
There are new Ubuntu Pro 20.04 images available in the Azure marketplace with SQL...
I have a parameter in my report labeled as PaySource. PaySource has 3 values...
Has anyone had issues with CloudStrike Anti-Virus on their SQL Servers? I've had a...
I created a date field [Datte] in SQL v2008. I then link with MS...
Ask SSC