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...")
 
 
(One intermediate revision by the same user not shown)
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"