In this guide we are going to walk you through exporting and importing your MSSQL stored procedures within SQL management studio.
All shared web hosting customers now have the option to use either MS SQL Server 2008 rather than MS SQL Server 2005.
In this tutorial we will show you how to connect to a MS SQL server using MS SQL Server Management Studio. In here you can do database queries in a few clicks.
In this tutorial we are going to walk you through backing up your MSSQL databases using MyLittleBackup. This back up process will create a .bak file. myLittleBackup for SQL Server 2000, 2005 and 2008 is the first Backup/Restore solution specially … Continue reading
This page has been designed to be a one stop guide to help you back up all of your Pipe Ten website’s data, we will show you how to create a full back up of your hosting account including databases, … Continue reading
There is an occasional requirement to manually move your database from one server to another. Typically this is required as the result of an account migration between data centres.
If you receive an email from firstname.lastname@example.org or .com with the title “Warning (Approaching resource limit)” it means that you are approaching or exceeding some of the inclusive resources on your hosting package. Explanations of what these resources are and … Continue reading
When you reach approach or exceed the default size of your hosting packages inclusive database quota/storage you will receive an email from email@example.com or .com to the primary account contact with the subject “Warning (Approaching resource limit)”. This post provides … Continue reading
When connecting to an MS Sql 2005 Server using MS SQL Server Management Studio 2008 you may come across an error “Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)”. This in turn will prevent you from being able to connect … Continue reading
Support for the old MS SQL Manager that used to be available via the online control panel has been removed. This was because of the lack of functionality, security risks and general poor performance that the third party package was … Continue reading
Pipe Ten are please to announce a beta release of MyLittleAdmin, the web based administration tool for SQL servers.
Due to popular request Pipe Ten have now launched their exciting new SQL Server 2005 backup facility using MyLlttleBackup. All customers that have databases on Pipe Ten’s MSSQL server can now log in to the new online backup facility to … Continue reading
Please note this guide will only copy database tables, not stored procedures, views, functions, or SQL rules. This FAQ assumes SQL Server 2005 Express is running on your development server.If not already installed you will need the Microsoft SQL Server … Continue reading
You can obtain Enterprise Manager by downloading MSDE (Microsoft Data Engine) from Microsoft
There are a range of clients available for managing your MS SQL 2005 database and they all should work with Pipe Ten’s servers without a problem. Each client offers slightly different functionality and licensing. Below are two of the more … Continue reading
Connecting to MS SQL Database using a remote client Yes It Is possible to connect to your Database with various SQL Client’s. We only enforce standard authentication for remote MS SQL connections, you just require your database username, password and … Continue reading