Difference between revisions of "Tables Not Listed - MS SQL"

From Hostek.com Wiki
Jump to: navigation, search
(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:
  1. Click on "MS SQL"
  2. Click the "Edit" button next to the database
  3. Select your database user from the "Database Owner" drop-down menu
  4. 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.
Retrieved from "https://wiki.hostek.com/index.php?title=Tables_Not_Listed_-_MS_SQL&oldid=511"