To doraemon2000

Results 1 to 2 of 2
  1. #1
    Member Edmond1113 is offline
    MemberRank
    Apr 2006 Join Date
    52Posts

    To doraemon2000

    Hi! You said that(in this website) http://forum.ragezone.com/post1025327.html

    I have added all code into the Database but there is a message:

    Msg 1801, Level 16, State 3, Line 1
    Database 'LNF' already exists.
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'NavyFIELDUserInfo'.


    And I added the codes like this(I added the codes in the last line):

    .
    .
    .
    GO
    ALTER DATABASE [LNF] SET PAGE_VERIFY CHECKSUM
    GO
    USE [LNF]
    GO
    IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE [LNF] MODIFY FILEGROUP [PRIMARY] DEFAULT
    GO
    INSERT INTO NavyFIELDUserInfo (ID,Password,rank,y14,b_type1,b_type2,is_flag,Gainflag,Gaincount,LevelFlag) VALUES ('<1113>','<98124987>', '0','1','1','0','0','0','0','0')
    select memberinfo from NavyFIELDUserInfo where ID= '<1113>'
    INSERT INTO billdate_1 (user_index,b_untildate) VALUES ('<1113>','2008-1-1' )





    Please help me!!!


  2. #2
    Account Upgraded | Title Enabled! doraemon2000 is offline
    MemberRank
    Nov 2004 Join Date
    Toronto, CanadaLocation
    470Posts
    ...where'd that top part come from?

    And are you sure you setup your MSSQL server properly?



Advertisement