WebCheatSheet offers technical articles, database tools, tips, and tutorials. Here you'll find everything you need to know to look like you know everything.
Your users probably asked you to add an option to export the whole database to SQL file. This can be done in phpMyAdmin or Navicat of course but your users want something simpler than that.
Last Updated ( 15 April 2012 ) Hits: 1295 Comments: 0 Read More...
All of sudden SQL Server Management studio gives me the following error message when I'm trying to browse for the backup file location: "Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'.
This property may not exist for this object, or may not be retrievable due to insufficient access
rights. (Microsoft.SqlServer.Smo)"
Last Updated ( 4 January 2012 ) Hits: 152 Comments: 0 Read More...
After upgrading MySQL from version 5.0 to 5.5 I started getting the following message trying to edit table structure in Navicat: "Cannot load from mysql.proc. The table is probably corrupted". Luckily there is an easy fix.
Last Updated ( 4 January 2012 ) Hits: 131 Comments: 0 Read More...