Post reply

You are the DBA at a multinational company...

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

  • 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)

  • December 2, 2024 at 3:29 pm

    #4492191

    support for these data types was introduced in sql2005 - instead of keeping the data in the row, pointers to other pages are used to enable larger chunks of memory for NVARCHAR(MAX) etc

    At the end of most articles is a small blurb called a person's signature which exists to provide information about how to get in touch with the person posting, including their email address, phone number, address, or where they're located. Signatures have become the graffiti of computers. People put song lyrics, pictures, philosophical quotes, even advertisements in them. (Note, however, that advertising in your signature will more often than provoke negative responses until you take it out.)

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

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