NP. I did not explain what I needed well.

LadyDee - How do I mark this as solved

Yes, thank you so much, just what I needed. I appreciate your time in assisting me.

LadyDee

In all the table from my initial posting I want them to have a relationship and I and not sure how to do this.

LadyDe

The table would look like this = RegionID, region, state, abbreviation, postal code. Hope this is what you need.

I have not created the tables yet.

LadyDee

One region is DeepSouth, which would have Alabama, Ala - abbreviation and AL as postal Code.

LadyDee

I did not mean the function key sorry, I meant the foreign key. I realize I have to make something like regionID for the primary keys.

Thank you

LadyDee

I am a newbie, so do not know how to run sxstrace cause it need parameters:

I do know that so far I have this:

Overall summary:

Final result: ...

I still need assistance with this. I need to study for my test in June.

Thank you

I read the attachment and all of this sounds complicated. Is there some fix that can be downloaded for this. I was not doing anything with SQL when...

Yes, some of these applications use MySql which I had installed already. But I installed PHP for .NET and tried to install MySQL for .NET but port 3306 is...

I am tryiing to loging remotely from sites that will install the web platform which is can be used with Visual

Studio.

Thank you

LadyDee

No matter what I have done, I can not get this process to work, could you please write an example of what I should be doing based off of the...

When trying to set these not null columns in the table is am using, I use the alter function and it will not let me make these columns null.

Thank you

LadyDee

Table to insert from:

USE [Darlene]

GO

/****** Object: Table [dbo].[Abco] Script Date: 09/16/2008 13:13:06 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Abco](

[Manufacturer_ID] [int] NOT NULL,

[name] [varchar](60) NOT...

I am getting the following error:

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)

Messages

* Warning...