FormatDateTime ASP Classic provides FormatDateTime function which allows you to format a valid date or time expression. For date, it allows you to select two formats: vbLongDate, and vbShortDate. …
You receive the error message while trying to execute a program: "The program can't start because MSVCR110.dll is missing from your computer. Try reinstalling the program to fix this …
Import Large SQL file Using MySQL command line When you want to restore database from a SQL backup file to your MySQL server on web server, you can simply …
Fix Error Setting Write Mode Page on UltraISO UltraISO is an ISO CD/DVD image file creating, editing, converting tool and a bootable CD/DVD maker. It can directly edit the …
By default configuration, SQL Server allows only Windows authentication mode. However, if you have some legacy or custom application that needs to access SQL Server using ‘sa’ account, you …
There are many benefits of sample databases, for example, it can be use for learning or studying database-related subjects, or use to test your script/query, etc. In those previous …
When you need to execute a command, sometimes you may need an elevated command prompt (a command prompt with administrative privilege). Otherwise, you may receive error message, for example, …
I wrote articles about how to enable remote connection on SQL Server 2008 and SQL Server 2005 many years ago. However, I want to keep its content more up-to-date …