Close Window x

Frequently Asked Questions

Help Center Search

MS SQL Articles

Connecting to a Microsoft SQL Server Database Using ASP/ADO

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

Importing SQL Server Database Objects

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

How do I change the password for my MS SQL database?

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

How do I change the description of my MS SQL database?

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

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 Data into a SQL Server Database

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

What are the limitations for MS SQL?

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

How do I Export a SQL Server database?

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

How do I connect to SQL Server using Visual Studio?

You can connect to SQL Server database using Visual Studio by enabling Direct Database...

Limitations of the Database Publishing Service in the Shared Hosting Environment

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

Importing Data from MS Access to MS SQL

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

Setting up a SQL Server Database on Your Hosting Account

The article you are looking for has moved. If your browser does not automatically...

Which version of MSSQL do you support?

All new databases created are in MSSQL 2005 format. MSSQL 2005 is backward compatible...

What are the new features available in MSSQL 2005?

MSSQL 2005 offers many new features, including: Native XML Support - Native XML...

What is MARS and how do I use it?

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

Creating SQL Server Database Tables and Fields

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

Publishing a Database That Includes CLR Assemblies

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

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.

Limitations to Restoring .bak Files

When restoring a SQL Server database back-up file, you are limited to using .bak files...

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...

Where do I get the Database Publishing Wizard client?

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

Configuration Information for the Database Publishing Wizard

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

What does my Database Publishing Wizard error mean?

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

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...

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....

Publishing a Full Text Catalog

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

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...

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...

Do you restrict any features in MSSQL 2005?

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

How can I install/uninstall ASP Schema from my MSSQL database?

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

How do I install/uninstall DSN in my MSSQL Database?

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

Where can I find database connection strings for my MS SQL database?

Connection strings can be found in the Hosting Control Center. Log in to your...

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...