Forum Replies Created

Viewing 14 posts - 361 through 374 (of 374 total)

  • RE: Diagrams are empty

    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...

  • RE: There is already an object named PK_Survey_Category in the database

    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

  • RE: DELETE statement conflicted with COLUMN REFERENCE constraint

    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...

  • RE: DELETE statement conflicted with COLUMN REFERENCE constraint

    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...

  • RE: ON DELETE CASCADE

    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...

  • RE: ON DELETE CASCADE

    Tymberwyld,

    I like people like you.

    Detail oriented, passioned to help.

    Thank you very much.

    I got the idea.

    Thanks a lot.

  • RE: Error creating FOREIGN KEY

    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

  • RE: Error creating FOREIGN KEY

    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...

  • RE: Error creating 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...

  • RE: CREATE RULE

    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...

  • RE: CREATE RULE

    [1-9] doesn't work

    [1][0] doen't make sense

    And how do I restrict

    to any two characters?

    _ _?

  • RE: CREATE RULE

    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]

    ...

  • RE: TRIGGERS and @@IDENTITY

    Thank you!

    Works perfectly!

    quote:


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


    ...

  • RE: SELECT * INTO #t1

    Allen_Cui!

    You must be a T-SQL Guru!!!

    Thanks a lot!

    Works beautiful.

    Robert Opeshanksy

Viewing 14 posts - 361 through 374 (of 374 total)