Tables Not Listed - MS SQL
From Hostek.com Wiki
Revision as of 22:45, 27 July 2012 by Briana (Talk | contribs) (Briana moved page Common Issues - MSSQL to Tables Not Listed - MS SQL without leaving a redirect)
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.