Tag Archives: tables

SQL Server database and table listing

Leave a comment

I generally work with MySQL, not MS SQL Server. So when I needed some basic automated info about a SQL Server’s database/table layout I was thankful for the following two pages: Get list of databases from Sql Server – Stack Overflowhttp://stackoverflow.com/questions/147659/get-list-of-databases-from-sql-serverHow can I get the list of available databases on a SQL server instance? I’m planning to make a list of them in a combo box in vb.net. Get a list of all database on a SQL Server: SELECT name

Read more Misc Links, Software Tips, Work

[Err] [Bak] 1286 – Unknown table engine ‘InnoDB 00:00:00’

Leave a comment

Last night I had an error show up a couple times while using Navicat to backup database on Weblogs.us. This was the error: [Err] [Bak] 1286 – Unknown table engine ‘InnoDB 00:00:00’ On this server MyISAM was preferred so I had specifically disabled InnoDB, yet something was trying to deal with InnoDB and it was causing the backup error . To determine which table(s) were causing the problem, I used the following SQL statement: SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA =

Read more computer tips, Weblogs.us, Work