diff options
Diffstat (limited to 'system/database/drivers/sqlsrv/sqlsrv_utility.php')
| -rw-r--r-- | system/database/drivers/sqlsrv/sqlsrv_utility.php | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/system/database/drivers/sqlsrv/sqlsrv_utility.php b/system/database/drivers/sqlsrv/sqlsrv_utility.php index 5830c62de..2ef6b240e 100644 --- a/system/database/drivers/sqlsrv/sqlsrv_utility.php +++ b/system/database/drivers/sqlsrv/sqlsrv_utility.php @@ -41,7 +41,7 @@ class CI_DB_sqlsrv_utility extends CI_DB_utility { */ public function _list_databases() { - return "EXEC sp_helpdb"; // Can also be: EXEC sp_databases + return 'EXEC sp_helpdb'; // Can also be: EXEC sp_databases } // -------------------------------------------------------------------- @@ -52,11 +52,11 @@ class CI_DB_sqlsrv_utility extends CI_DB_utility { * Generates a platform-specific query so that a table can be optimized * * @param string the table name - * @return bool + * @return string */ public function _optimize_table($table) { - return FALSE; // Is this supported in MS SQL? + return 'ALTER INDEX all ON '.$this->db->protect_identifiers($table).' REORGANIZE'; } // -------------------------------------------------------------------- @@ -71,7 +71,8 @@ class CI_DB_sqlsrv_utility extends CI_DB_utility { */ public function _repair_table($table) { - return FALSE; // Is this supported in MS SQL? + // Not supported in MSSQL + return FALSE; } // -------------------------------------------------------------------- @@ -80,7 +81,7 @@ class CI_DB_sqlsrv_utility extends CI_DB_utility { * MSSQL Export * * @param array Preferences - * @return mixed + * @return bool */ public function _backup($params = array()) { |