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
625 reads
By Steve Jones
One of the newer features in Data Masker for SQL Server is the ability...
Yesterday in this post I described a method to correct permissions when upgrading a...
By Devin-Knight
Welcome back to my Power Platform Quick Tips series! In this second episode we...
Comments posted to this topic are about the item Numeric and Decimal, which is...
For some reason I'm unable to create another log file. Ideas? ALTER DATABASE [DBNAME]...
One of our machines is not able to connect to sql server It gives...
Ask SSC