Archive | SQL Server

Let us understand the SQL server 2005 installation error which displays a message “There was an unexpected failure during the setup wizard”.

If we have already taken our Microsoft SQL Server database backup then we are now bit safe and lucky than others. But if we don’t know the procedure to restore the backup database then simply God knows our future.

Never even in dreams compare the significance of regular database backup with time, energy and money.

Yesterday night was almost ruined when I tried to connect my special VB.net project with Microsoft SQL Server 2005 in Vista operating system.

After the creation of the database the next work is to create/design tables in SQL server 2005 as per our requirement.

Understanding the data types of SQL Server 2005.

There is a hell and heaven difference between the concept of SQL SERVER 7.0 and SQL Server 2005. But the procedure for creating a database in SQL server 2005 in almost same as it was in the older versions of the software.

Both SQL server 2005 standard edition and SQL server express edition are compatible with Microsoft Windows Vista.

Well, older version of SQL server is not compatible with Windows Vista. But SQL server 2005 standard edition and SQL server express edition is highly compatible with window Vista.

Well the bitter side of Windows Vista is that it is highly incompatible with any version of SQL server. Vista and SQL server belongs to the same company Microsoft.