Servergrid UserLink

Hello to all :

My question is How Can I upload a new table to my SQL Server database ? I can download and get a local copy of the tables stored in Web Server database, (using the option Import data from SQL server manager software)  but when I triying to  upload a new table (using the option export data) I see the message user dont have permision, How can I get the permission necesary to make this task ? Thanks Very much!

Hi,  You can backup the database on your local system using SSIS or DTS (depending upon which version of MSSQL server your are on).  The following link has more information on using DTS or SSIS.  http://servergrid.com/support/article.aspx?id=13975  Also you may want to make sure you have granted DBO permissions on the SQL database before you attempt to backup or restore the SQL database.  https://www.servergrid.com/support/sqltools.aspx  That link will help you grant DBO permissions.  Also if you wish to just edit and add a single table you can use our MSSQL manager that we provide at the following link.  https://servergrid.com/mssql  When you access the https://servergrid.com/mssql link, please make sure you are using Microsoft Internet Explorer.  Also the following link has a list of known MSSQL managers you can use to manage your SQL database.   http://servergrid.com/support/article.aspx?id=13933

Thank you.