Small Tip, Restore Database with replace "MSSQL 2005"

RESTORE DATABASE AdventureWorks
    FROM DISK = 'C:\BackupAdventureworks.bak'
            WITH REPLACE

List of countries, cities, languages

You will find in the following links list of countries, cities, and their languages in CSV format, you can import into any database:

Countries:

http://www.ziddu.com/download/1936707/Country.csv.html

Cities:

http://www.ziddu.com/download/1936708/City.csv.html

Languages:

http://www.ziddu.com/download/1936713/Language.csv.html

and the following is the sql script to create these tables in sql server 2005:

USE [World]
GO
/****** Object:  Table [dbo].[City]    Script Date: 08/16/2008 14:48:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[City](
  [ID] [int] NOT NULL,
  [Name] [nvarchar](35) COLLATE Arabic_CI_AS NOT NULL,
  [CountryCode] [nvarchar](3) COLLATE Arabic_CI_AS NOT NULL,
  [District] [nvarchar](20) COLLATE Arabic_CI_AS NULL,
  [Population] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Country]    Script Date: 08/16/2008 14:48:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Country](
  [Code] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [Name] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [Continent] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [Region] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [SurfaceArea] [nvarchar](150) NOT NULL,
  [IndepYear] [nvarchar](150) NULL,
  [Population] [nvarchar](150) NOT NULL,
  [LifeExpectancy] [nvarchar](150) NULL,
  [GNP] [nvarchar](150) NULL,
  [GNPOld] [nvarchar](150) NULL,
  [LocalName] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [GovernmentForm] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
  [HeadOfState] [nvarchar](150) COLLATE Arabic_CI_AS NULL,
  [Capital] [nvarchar](150) NULL,
  [Code2] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,
CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED
(
  [Code] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Language]    Script Date: 08/16/2008 14:48:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Language](
  [CountryCode] [nvarchar](50) COLLATE Arabic_CI_AS NOT NULL,
  [Language] [nvarchar](50) COLLATE Arabic_CI_AS NOT NULL,
  [IsOfficial] [bit] NULL,
  [Percentage] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
CONSTRAINT [PK_Language] PRIMARY KEY CLUSTERED
(
  [CountryCode] ASC,
  [Language] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

Subsonic going visual ( SubStage )

Subsonic is going up in subsonic,

everyday we feel how subsonic is a very good tool.

They created a good visual tool called SubStage to easily  generate code.

http://subsonicproject.com/2-1-pakala/using-substage/

 

Show hide system objects SQL Server's Enterprise Manager

If you want to show or hide the system objects in SQL server's enterprise manager such as "master database, system tables, system stored procedures":

1- In SQL Server 7.0 and SQL Server 2000:

Step 1:

Step 2:

2- In SQL Server 2005's Management Studio:

Step 1:

Step 2:

Hint: In SQL Server 2005's Management Studio you will need to restart the management studio to make changes take effect.