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 shows a step-by-step guide to backup and restore a database between two Microsoft SQL Server 2005 instances. By using backup, you can backup a database without interrupt any transactions on the database.
In the example below, I will backup a database from SQL Server 2005 and restore the database to another SQL Server 2005 Express Edition.
I have been trained SQL Server 2005 several months ago but I haven’t time to summarize yet so I’m going to write as much as possible. The training course concerns about using MS SQL Server 2005 with MS Visual Studio Visual Basic.NET so some part may contains source code in VB.NET. Most of contents will express using example and figure if you need reference or more detail of functions, you can try search at MSDN, Microsoft.com. I hope that these may be useful for programmers to review.
The training consumes 5 days so I’ll categorize this by days and also separate each day into 2 parts because it’s quite long. Read the rest of this entry »
By default, SQL Server 2005 doesn’t allow remote connection so you have to enable it manually. If you try to connect to remote SQL Server without enable remote connection first, you’ll see one of these error messages.
This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 2.5 License.