Social Website Database -Online application RSS

• • Reply
  

  TimoYang

  Contributor

  3732 Points

  1275 Posts

  Re: Social Website Database -Online application

  Jun 15, 2012 06:38 AM|LINK

  Saby2012

  I open SQL Management studio> file> open > select the file ...

  No, just plz open SQL studio and create a Query file by clicking the "New query" and paste the codes inside and press f5……

• • Reply
  

  Saby2012

  Member

  160 Points

  150 Posts

  Re: Social Website Database -Online application

  Jun 15, 2012 06:45 AM|LINK

  Ok i did;

  i got this under Message windo:

  Msg 2627, Level 14, State 1, Line 2
  Violation of PRIMARY KEY constraint 'PK_Grades'. Cannot insert duplicate key in object 'dbo.Grades'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 2
  Violation of PRIMARY KEY constraint 'PK_Roles'. Cannot insert duplicate key in object 'dbo.Roles'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 3
  Violation of PRIMARY KEY constraint 'PK_Roles'. Cannot insert duplicate key in object 'dbo.Roles'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 4
  Violation of PRIMARY KEY constraint 'PK_Roles'. Cannot insert duplicate key in object 'dbo.Roles'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 2
  Violation of PRIMARY KEY constraint 'PK_Users'. Cannot insert duplicate key in object 'dbo.Users'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 3
  Violation of PRIMARY KEY constraint 'PK_Users'. Cannot insert duplicate key in object 'dbo.Users'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 4
  Violation of PRIMARY KEY constraint 'PK_Users'. Cannot insert duplicate key in object 'dbo.Users'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 5
  Violation of PRIMARY KEY constraint 'PK_Users'. Cannot insert duplicate key in object 'dbo.Users'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 2
  Violation of PRIMARY KEY constraint 'PK_Courses'. Cannot insert duplicate key in object 'dbo.Courses'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 3
  Violation of PRIMARY KEY constraint 'PK_Courses'. Cannot insert duplicate key in object 'dbo.Courses'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 2
  Violation of PRIMARY KEY constraint 'PK_Book'. Cannot insert duplicate key in object 'dbo.Book'.
  The statement has been terminated.
  
  (1 row(s) affected)
  
  (1 row(s) affected)
  
  (1 row(s) affected)
  
  (1 row(s) affected)
  Msg 2627, Level 14, State 1, Line 2
  Violation of PRIMARY KEY constraint 'PK_UserRoles'. Cannot insert duplicate key in object 'dbo.UserRoles'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 3
  Violation of PRIMARY KEY constraint 'PK_UserRoles'. Cannot insert duplicate key in object 'dbo.UserRoles'.
  The statement has been terminated.
  Msg 2627, Level 14, State 1, Line 4
  Violation of PRIMARY KEY constraint 'PK_UserRoles'. Cannot insert duplicate key in object 'dbo.UserRoles'.
  The statement has been terminated.