Connect to MySQL through PHP
Use the following outline to connect and begin querying the MySQL server from within your PHP scripts. Connect to the MySQL server Use the following …
Latest articles
“Cannot connect to the database” errors
Here are a few initial things (common mistakes) to take a look at: – Make sure that after you created your database and database user …
MySQL will not start, “MySQL File ‘/usr/share/mysql/charsets/?.conf’ not found” in error log.
The most common cause for this error, is a failed downgrade of MySQL from 4.1 to 4.0. Many changes were made between MySQL 3.x, 4.0.x, …
Enable the full text indexing for a MSSQL database
Syntax sp_fulltext_database Initializes full-text indexing or removes all full-text catalogs from the current database. sp_fulltext_database [@action =] ‘action’ Arguments [@action =] ‘action’ Is the action …
View the Contents of a Table in a SQL Server Database Using Enterprise Manager
How to View a Table in a SQL Server Database Need to know how you can view a table within a SQL server database? Using …
Connect to my MSSQL database via Enterprise Manager?
To connect to your MSSQL database using Enterprise Manager, please perform the following: 1. Bring up Enterprise Manager. 2. Go to menu “Action”->”New SQL Server …
Export the data from different tables in our shared SQL environment?
Using Enterprise Manager Expand SQL Server group Expand the server name Expand Databases Expand the database that you’ll be exporting data from Click on Tables …
Reset the SQL Server ‘sa’ user password?
Open Enterprise Manager and expand the registered SQL server. Expand Security. Click on Logins. Right-click the user “sa” and select Properties. Type the new password …
Restrict clients using my SQL Server by their IP Address?
SQL Server has no built-in support for restricting clients by IP address. The most common work-arounds are firewalls, IPSec, or third-party network layer filters to …
How to Restore a Database on SQL Server Using .mdf, .ldf and .ndf Files
To restore a database on SQL Server using .mdf, .ldf, or .ndf files, rather than performing a restore, you will actually need to attach the …
Shrink MsSql DB Logs
1. Open query analyser. Do not open Enterprise Manager. 2. Let the database be selected as “Master” 3. Fire the command BACKUP LOG “DATABASE_NAME” WITH …
Showing 815 - 825 of 1347 articles