Post reply

Generate PK in SQL7 vs SQL2000 using DMO

  • September 11, 2002 at 3:42 pm

    #80122

    Is there a different way to code SQLDMO to generate a unique name for a primary key in SQL7 vs. SQL2000? I am getting an error when running an app written for SQL2000 against MSDE1.0 (SQL7).

    SQL7 trace shows a unique name of N'PK_(null)_', 1 OR with Error N'PK_garbage chars

    SQL2000 trace shows unique name of N'PK_NameOfTable_', 1 and no error occurs

    Any help is appreciated.

  • September 11, 2002 at 8:18 pm

    #436361

    No idea. Looks like you're running into a few compatibility issues. Tried a search on MSDN or google to see if you can maybe find a list? Would be interesting to see one! Short of that you may have to just run your code against SQL7/MSDE to identify what breaks and implement work arounds. Sorry Im not more helpful.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply