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

From Hostek.com Wiki
Jump to: navigation, search
m (Briana moved page Common Issues - MSSQL to Tables Not Listed - MS SQL without leaving a redirect)
 
Line 8: Line 8:
 
# Click '''"Save"'''
 
# 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.
 
  
 
[[Category:Databases-MSSQL]]
 
[[Category:Databases-MSSQL]]

Latest revision as of 22:46, 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"
Retrieved from "https://wiki.hostek.com/index.php?title=Tables_Not_Listed_-_MS_SQL&oldid=512"