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,011 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
626 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing...
By Steve Jones
I presented a session today at Redgate Streamed and did a number of demos....
First time poster...not sure this the correct section to post this question. I have...
I am using this statement: Select @Data = @Data + RIGHT('00000000000' + CAST( (SUBSTRING(STR(@qtramt1),1,11))...
Hi all I have an issue when i try this it gives me an...
Ask SSC