The databases, such Northwind and Pubs, are sample databases which are used for testing and developing on SQL Server. They are widely used in many sample source code and referenced by many tutorials. So if you are a developer or want to learn about SQL on SQL Server, these databases are needed to be installed on your development PC.
Note: This article is applied on installing Microsoft SQL Server Management Studio Express which is used for manage Microsoft SQL Server 2005 Express only.
If you execute a vb script which use SQL-DMO on SQL Server 2008, you will notice that the script doesn’t work at all.
On Part 1: Introduction, I mentioned about error messages when you try to restore a database from SQL Server 2008 to SQL Server 2005. You can see the first solution at Part 2: Generate SQL Server Scripts Wizard. Now let’s see the second solution to solve the problems.
On Part 1: Introduction, I mentioned about error messages when you try to restore a database from SQL Server 2008 to SQL Server 2005. Now let’s see a first solution to solve the problems.
When you restore or attach a database which is created from SQL Server 2008 to SQL Server 2005 or SQL Server 2000, you will see some error messages as the examples below.
You have backup a database on SQL Server 2005. Then, you try to restore the backup file on an existing database and receive the error message below:
You have backup a database on SQL Server 2005. Then, you try to restore the backup file on the existing database and receive the error message below:
Last time, I wrote an article show how to enable remote connection on SQL Server 2005 Express. Now SQL Server 2008 Express is released for a while, it doesn’t allow remote connection on default installation as on SQL Server 2005 Express. So you have to enable it manually.
When you create a store procedure on Microsoft SQL Server with some input parameters, sometimes you don’t want to assign all of parameters (optional parameters) so you need to specify default value for the parameters. Otherwise, it shows error when execute the store procedure.
This part contents mostly concerns coding on VB.NET which will interacts with SQL server on pubs database. The sample database can be download at SQL2000SampleDb. You do not need to complete Part I before.
This post will give you a brief introduction of SQL Server backup. As we know, SQL Server backup software is springing up nowadays. Take EaseUS Todo Backup Advanced Server as an example, it’s an all-in-one SQL server backup software for MS SQL Server 2000/2005/2008, exchange server and server 2000/2003/2008, and provides proven database backup solution for Server administrators.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.