Difference between revisions of "Tables Not Listed - MS SQL"
From Hostek.com Wiki
(Created page with "==Database Tables Not Listed== * If you are unable to see any of the tables in your MSSQL database using SQL Management Studio you may need to set your database user as the da...") |
m (Briana moved page Common Issues - MSSQL to Tables Not Listed - MS SQL without leaving a redirect) |
(No difference)
|
Revision as of 22:45, 27 July 2012
Database Tables Not Listed
- If you are unable to see any of the tables in your MSSQL database using SQL Management Studio you may need to set your database user as the database owner.
- You can set your database user as the database owner in the WCP by doing the following:
- Click on "MS SQL"
- Click the "Edit" button next to the database
- Select your database user from the "Database Owner" drop-down menu
- Click "Save"
Backing Up Database
- Backing up your database in SQL Management Studio is not supported on our MS SQL database servers.
- The reason for this is that doing this creates a backup file on the database server which can be very large depending on the size of your database.
- If you need a copy of your database you'll need to use the MyLittleBackup Tool in your WCP.