10/31/2011 03:16 by maxkitty
Open SQL Server Enterprise Manager, then expand your "SQL Server Group." Expand <server name>, then expand "Databases."
Expand your database, then click the "Tools" menu. Click "SQL Query Analyzer" and type the following to view the user tables available in this database:
select * from sysobjects where xtype='U'
Type the following to view system tables available:
select * from sysobjects where xtype='S'
Press "F5" to run your query and view results.
A: Open SQL Server Enterprise Manager, then expand your "SQL Server Group." Expand <server name>, then expand "Databases." Expand ...(more)
A: Backup and restore Joomla using phpMyAdmin. The phpMyAdmin utility is typically installed by your hosting provider within their administra...(more)
A: Install MySQL onto your machine and connect it to the server. Provide a MySQL user name and password at the prompts. When you see the "mys...(more)
A: Download the AJAX plug-in. Log in to your Joomla account. Click on the "Installer" button, select "Components". Select the zippe...(more)
A: Open the MySQL query tool. Type a query that locks the table. For example, to prevent others from reading data while you perform your quer...(more)
Added Successfully!
×Voted Successfully!
×You can't vote for yourself
×You can't choose your own answer
×