Microsoft SQL Server Hosting

Question I would like to be able to connect to my MS-SQL database remotely, perhaps using a 3rd party application or using Management Studio. Is this possible? Answer Yes, it is possible for our Microsoft SQL 2008 databases. You will be able to connect remotely…

The following is an example of a correctly formatted .NET connection string for Microsoft SQL 2005/2008 database. Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Issue You require a full text catalog to be configured for your database. How do you do this? Solution Contact customer service on 0800 5000 24 or service@net24.co.nz with the fields that require full text catalog and we will configure this for you. Remember…

Issue When dates are input this produces an error similar to : The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value Solution When you are working with dates in SQL server use the internationalised ISO…

Issue While attempting to restore your database using MyLittle Backup you receive the following error: The media set has 2 media families but only 1 are provided. All members must be provided. Cause This error is due to your backup being divided into more…

Issue When trying to edit some tables there is no edit/drop icons displayed. Solution The table needs to have a primary key defined in order to have edit/drop icons available. Create a primary key on these tables and you will then be able to edit rows.

Issue After attempting to restore a database using the MyLittleBackup utility, the restore failed with errors and has now left your database inaccessible. Cause While restoring your database, the database is put into Single_User access mode which prevents…