I don't know how much data you already have in your database but you could add an Unspecified for the records that do not have a country but have a...

No as was stated you can't alter an existing column to make it an identity column but you...

Please refer to the following - FYI:

http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/04d69ee6-d4f5-4f8f-a115-d89f7bcbc032

It has been a long time but I implemented an International Trade Database.

It had a Codes for the Continent, Sub Continent and Country with Lookup Tables for each.

I prefer the Oracle Driver over the Microsoft Client Driver.

What is installed on the machine in which it is created?

For instruction on installing the Microsoft OLE DB Provider for...

I forgot to ask you what version of Oracle you are using?

I noticed this old article about this...

32 or 64 bit?

Sounds like you are missing the MSORA Driver that the connection is using.

I just recalled having a similar problem and it turned out to be the NIC Card was configured to Auto.

I changed it to Full Duplex and that resolved the problem.

I would insert...

Is sqlsrv the actual Login Name?

Perhaps I was not clear on what you need to do but you need to create a script to load your test data into the table that you defined.

prashantcomp90 (5/20/2011)

---

USE [bank]

GO

/****** Object: Table [dbo].[ledger] Script Date: 05/21/2011 01:41:25 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[ledger](

[vec] [numeric](25, 0) IDENTITY(1,1) NOT NULL,

[id] [varchar](20) COLLATE...

In SSMS, select the table, right...

Michael Valentine Jones (5/20/2011)

---

Welsh Corgi (5/20/2011)

---

Michael Valentine Jones (5/20/2011)

---

Welsh Corgi (5/20/2011)

---

I'm sure that the USNO has it's reasons but the US Military Finance and Accounting, etc advances the Julian Date...