You are the DBA at a multinational company...

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734418

  More actions

  December 19, 2007 at 5:03 am

  #62993

  Comments posted to this topic are about the item You are the DBA at a multinational company...

• malleswarareddy_m

  SSCertifiable

  Points: 5847

  More actions

  March 26, 2010 at 6:29 am

  #1140274

  Hi Steve jones,

  I have created the table as given in question.but it will not given an error or warning message.I shows

  commands executed sucess fully.Even though I put SET ANSI_WARNINGS ON.

  I know that maximum row size is 8060 bytes.but is it for only SQL server 2000.

  I think that for SQL server 2005 there is also same limit.

  Please sepcify why i did not got error message when i ran this query in ssmo using SQL server 2005.

  Malleswarareddy
  I.T.Analyst
  MCITP(70-451)