PROBLEM Solved.

Apprently VS SP6 has a bug.

I wouldn't suggest to install it at all.

You need to replace MDT2DF.DLL (version 2.0.0.9586)

in

C:\Program Files\Common Files\Microsoft Shared\MSDesigners98

by

MDT2DF.DLL from SP5 (version 2.0.08958)

Here is what I...

Hi Steve Jones,

You are right.

PK_Survey_Category existed already in

a different table.

INFORMATION_SCHEMA.TABLE_CONSTRAINTS

helped.

Thank you for your help.

RobO

Thank you all!

It was my mistake.

Instead of having "ON DELETE CASCADE"

I selected "ON UPDATE CASCADE"

and didn't take care of the children in [User_Organization].

Sorry!

But you helped me to realize what I'm...

Hi iyerganapas,

Why it won't allow me to delete?

Correct me if I'm wrong.

I have UserID=133 in [User].

In [User_Organization] I have UserID=133 OrgID=234.

I have...

Thank you all!

I decide to use ON DELETE CASCADE

because this what I do in code anyway.

And I'm going to inform all in our group about that

and I will be careful.

Thanks...

Tymberwyld,

I like people like you.

Detail oriented, passioned to help.

Thank you very much.

I got the idea.

Thanks a lot.

Thank you Jonathan!

You helped me to discover

a very stupid thing

in our database design.

Somebody else created this database

and I'm responsible for

maintaining the ASP Application

Jonathan,

I ran your ALTER TABLE

and got this error:

Server: Msg 1778, Level 16, State 1, Line 1

Column 'User.Username' is not the same data type as referencing column 'ComponentsCompleted.User_ID' in foreign key...

Hi Jonathan!

Thanks for quick response.

That's exactly what I try to do

only in GUI

I create a RELATIONSHIP

USER.UserID -- COMPONENTS.UserID

What would be ALTER TABLE

script for COMPONENTS table?

I'll try it in Query...

I gave up.

I created a CONSTRAINT:

ALTER TABLE [dbo].[Organization] WITH NOCHECK ADD

CONSTRAINT [CK_Organization] CHECK (len([Name]) < 7

and (left([Name],2) = '03'

or (left([Name],2) = '02'

or left([Name],2) = '01'))

and...

[1-9] doesn't work

[1][0] doen't make sense

And how do I restrict

to any two characters?

_ _?

I know I can do that.

But the whole point is

I want to learn how

to use pattern matchin

in my rules.

Something like:

@value LIKE '[1-10]__[1-100]'

But it doesn't work

So I started with [1-10]

...

Thank you!

Works perfectly!

quote:

---

Use SCOPE_IDENTITY instead of @@IDENTITY. Check out BOL for more info.

---

...

Allen_Cui!

You must be a T-SQL Guru!!!

Thanks a lot!

Works beautiful.

Robert Opeshanksy