Close Window x

Frequently Asked Questions

MS SQL Articles

Where do I get the Database Publishing Wizard client?

The latest version of the Database Publishing Wizard (DPW) client is available from...

What is the URL for the Database Publishing Service?

The URL for the Database Publishing Service (DPS) is located in the Database...

Is there a size limit on MS SQL databases?

Yes, MS SQL databases on our Windows Shared Hosting plans have a size limit of 200 MB.

Where can I get more information on the Database Publishing Wizard client?

The Database Publishing Wizard (DPW) project home page is located in the CodePlex SQL...

Installing or Uninstalling ASP Schema from MS SQL Databases

To take full advantage of ASP.NET's architecture and performance capabilities, you...

What does my Database Publishing Wizard error mean?

The Database Publishing Wizard (DPW) provides detailed errors when you may be able...

Configuration Information for the Database Publishing Wizard

To set up the Database Publishing Wizard, you will need the following information:...

Locating Your MS SQL Database Connection Strings

Your MS SQL database connection strings can be located in the Hosting Control Center....

What are the Database Publishing Service and Database Publishing Wizard?

The Database Publishing Service (DPS) and Database Publishing Wizard (DPW) are a set...

Publishing Objects Using the Database Publishing Wizard

The Database Publishing Wizard (DPW) runs under your hosting account credentials....

Updating Your MS SQL Database's Description

During the database setup process you entered a description for that database. This...

Publishing a Full Text Catalog

It is not possible to publish a full text catalog to one of our hosted SQL databases....

Publishing a Web Site Based on an ASP.NET Starter Kit

ASP.NET starter kits can be downloaded from the ASP.NET website . The following...

Resetting Your MS SQL Database Password

During the database setup process you chose a password for that database. You will...

What should I be aware of when using the Database Publishing Service in the hosted environment?

The Database Publishing Service (DPS) may alter the contents and structure of your...

Which version of MSSQL do you support?

We support the following versions of MS SQL: MS SQL 2005 MS SQL 2008 MSSQL...

Removing Databases from Your Hosting Account              

If you no longer need a database with your hosting account, you can delete it. To...

What is collation and can I change it on my MS SQL database?

Collation controls the way string values are sorted. The default collation sorts...

Limitations to Restoring BAK Files

When restoring a SQL Server database back-up file in the Hosting Control Center, you...

What are the Methods for Backing up my MS SQL Database?

There are several methods for backing up a MS SQL database. Dump A copy of the...

Importing MS SQL 2005 Databases into MS SQL 2008 Databases

You can import MS SQL Server® 2005 database information into MS SQL Server®...

What are the limitations for MS SQL?

We allow up to 100 simultaneous connections per MS SQL user. MS SQL Server...

Managing Your Hosting Account's Databases

Using our hosting accounts, you can delete or edit databases you create. To Manage...

Importing Data from MS Access to MS SQL

Currently, this procedure is not supported. However, there are methods to migrate...

Exporting SQL Server Databases

You can export your SQL server database to an XML or a CSV file from the SQL Server...

What is MARS and how do I use it?

What is MARS? Using Multiple Active Result Sets (MARS), you can maintain multiple...

Importing SQL Server Database Objects

When importing a SQL Server database from an existing hosting account to your Windows...

Connecting to a Microsoft SQL Server Database Using ASP/ADO

This example describes using ASP/ADO to connect to a Microsoft SQL Server Database....

Creating SQL Server Database Tables and Fields

You can create tables and fields only after you set up a SQL Server database. For...

Do you restrict any features in MSSQL 2005?

MSSQL 2005 provides many features which are powerful in an enterprise database...

Importing Data into a SQL Server Database

You can import data from a delimited file into your shared hosting account's SQL...

Which version of MS SQL Server should I choose?

Unless you have a specific reason to choose otherwise, we recommend using MS SQL 2008,...

Installing or Uninstalling DSN for MS SQL Databases

During the database setup process you entered a description for that database. This...

Limitations of the Database Publishing Service in the Shared Hosting Environment

Using your login credentials, you can perform all database actions through the...

Importing CSV Files into MS SQL Server Databases

If you want to import information into a Microsoft SQL Server® database, you can...

What version of SQL Server is supported by the Database Publishing Service and Database Publishing Wizard?

The Database Publishing Wizard (DPW) client works with all local versions of SQL...

Publishing Databases Including CLR Assemblies

For security reasons, you cannot directly publish assemblies. However, it is possible...